Обсуждение: number of weeks

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

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

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