Re: number of weeks - Mailing list pgsql-general

From Robert B. Easter
Subject Re: number of weeks
Date
Msg-id 00070404043400.01354@comptechnews
Whole thread Raw
In response to number of weeks  (<hikmat@laurel.4com.net.lb>)
List pgsql-general
On Mon, 03 Jul 2000, hikmat@laurel.4com.net.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



pgsql-general by date:

Previous
From: Philip Warner
Date:
Subject: Re: Re: [HACKERS] proposed improvements to PostgreSQL license
Next
From: "K. Ari Krupnikov"
Date:
Subject: Re: psql dumps core