Postgres Pro
Downloads
Home   >   mailing lists

Thread: number of weeks

number of weeks

From
Date:
is there a function that returns the number of weeks since the begining
of the year or the number of days

Re: number of weeks

From
Karel Zak
Date:
On Tue, 4 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
>

date_part() or to_char()

BTW. --- what is bad on postgresql docs?


                    Karel

Re: number of weeks

From
"Robert B. Easter"
Date:
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