diff options
| author | Bruce Momjian <bruce@momjian.us> | 1999-11-29 23:26:18 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1999-11-29 23:26:18 +0000 |
| commit | 1c5aec60bb72ec932d68c71d91147e5516796196 (patch) | |
| tree | ead86b20f04796b1f5ace59280dd208fa73114b0 /contrib/README | |
| parent | 1f747c67222842b93ad833675aca20001a6dd9f8 (diff) | |
| download | postgresql-1c5aec60bb72ec932d68c71d91147e5516796196.tar.gz | |
I finish devel. of Oracle compatible DateTime routines TO_CHAR(),
TO_DATE()
and PgSQL extension FROM_CHAR().
TO_CHAR() routine allow formating text output with a datetime values:
SELECT TO_CHAR('now'::datetime, '"Now is: "HH24:MI:SS');
to_char
----------------
Now is: 21:04:10
FROM_CHAR() routine allow convert text to a datetime:
SELECT FROM_CHAR('September 1999 10:20:30', 'FMMonth YYYY
HH:MI:SS');
from_char
-----------------------------
Wed Sep 01 10:20:30 1999 CEST
TO_DATE() is equal with FROM_CHAR(), but output a Date only:
SELECT TO_DATE('September 1999 10:20:30', 'FMMonth YYYY
HH:MI:SS');
to_date
----------
09-01-1999
In attache is compressed dir for the contrib. All is prepared, but I'am
not
sure if Makefile is good (probably yes).
Comments & suggestions ?
Thomas, thank you for your good advices.
Karel
------------------------------------------------------------------------------
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
Diffstat (limited to 'contrib/README')
| -rw-r--r-- | contrib/README | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/contrib/README b/contrib/README index a59880c265..e280186cb3 100644 --- a/contrib/README +++ b/contrib/README @@ -10,6 +10,14 @@ array - Array iterator functions by Massimo Dal Zotto <dz@cs.unitn.it> +bit - + Bit type + by Adriaan Joubert <a.joubert@albourne.com> + +dateformat - + Date Formatting to/from character strings + by Karel Zak - Zakkr <zakkr@zf.jcu.cz> + datetime - Date & time functions by Massimo Dal Zotto <dz@cs.unitn.it> |