Re: [GENERAL] number of weeks

[Robert B. Easter]

On Mon, 03 Jul 2000, [EMAIL PROTECTED] 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