On Mon, 03 Jul 2000, hikmat(at)laurel(dot)4com(dot)net(dot)lb wrote:
> is there a function that returns the number of weeks since the begining
> of the year or the number of days
-- Week number of the year
to_char(CURRENT_TIMESTAMP, 'WW');
-- Day number of the year
to_char(CURRENT_TIMESTAMP, 'DDD');
See the documentation at:
http://www.comptechnews.com/~reaster/postgres/functions2976.htm
--
Robert B. Easter