From: | Zakkr <zakkr(at)zf(dot)jcu(dot)cz> |
---|---|
To: | "Zot O'Connor" <zot(at)zotconsulting(dot)com> |
Cc: | postgres sql <pgsql-sql(at)hub(dot)org> |
Subject: | Re: [SQL] Week of year function? |
Date: | 1999-10-26 07:53:22 |
Message-ID: | Pine.LNX.3.96.991026094248.12578B-100000@ara.zf.jcu.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
in _any_ next PostgreSQL version (perhaps) will include the oracle compatible
to_char(datetime, text), this routine allows arbitrary formatting for
datetime-text outputs. Example:
template1=> select to_char(now(), 'My week: WW');
to_char
-----------
My week: 43
(1 row)
Zakkr
------------------------------------------------------------------------------
<zakkr(at)zf(dot)jcu(dot)cz> http://home.zf.jcu.cz/~zakkr/
Kim Project: http://home.zf.jcu.cz/~zakkr/kim/ (process manager)
FTP: ftp://ftp2.zf.jcu.cz/users/zakkr/ (C/ncurses/PgSQL)
------------------------------------------------------------------------------
...and cathedral dilapidate
From | Date | Subject | |
---|---|---|---|
Next Message | John Ridout | 1999-10-26 08:24:09 | RE: [SQL] Access and field sizes |
Previous Message | Bruce Momjian | 1999-10-26 04:58:31 | Re: [SQL] possible bug? |