Re: [SQL] Week of year function? - Mailing list 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@zf.jcu.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