]> granicus.if.org Git - postgresql/commit
I finish devel. of Oracle compatible DateTime routines TO_CHAR(),
authorBruce Momjian <bruce@momjian.us>
Mon, 29 Nov 1999 23:26:18 +0000 (23:26 +0000)
committerBruce Momjian <bruce@momjian.us>
Mon, 29 Nov 1999 23:26:18 +0000 (23:26 +0000)
commit1c5aec60bb72ec932d68c71d91147e5516796196
treeead86b20f04796b1f5ace59280dd208fa73114b0
parent1f747c67222842b93ad833675aca20001a6dd9f8
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/
contrib/README
contrib/dateformat/Makefile [new file with mode: 0644]
contrib/dateformat/test/Makefile [new file with mode: 0644]
contrib/dateformat/test/README [new file with mode: 0644]
contrib/dateformat/test/rand_datetime.c [new file with mode: 0644]
contrib/dateformat/test/regress.sql [new file with mode: 0644]
contrib/dateformat/to-from_char.c [new file with mode: 0644]
contrib/dateformat/to-from_char.doc [new file with mode: 0644]
contrib/dateformat/to-from_char.h [new file with mode: 0644]
contrib/dateformat/to-from_char.sql.in [new file with mode: 0644]