Hi,
this is my new (experimental) TO_CHAR() function (compatible with oracle),
it is available on: ftp://ftp2.zf.jcu.cz/users/zakkr/pg/TO_CHAR-0.1.tar.gz.
See example:
=======
abil=> select to_char('now', 'HH:MI:SS Day MON CC');
to_char
------------------------
20:12:02 Thursday Sep 19
abil=> select to_char('now', 'MM MON Month MONTH YYYY Y,YYY YYY YY Y');
to_char
----------------------------------------------
09 Sep September SEPTEMBER 1999 1,999 999 99 9
abil=> select to_char('now', 'DDD D WW SSSS'); to_char
--------------
273 4 39 72810
abil=> select to_char('now', 'hello year YYYY');
to_char
---------------
hello year 1999
========Any comments ? Zakkr