Re: Week of the Year?

Try using the function date_part such as:

select date_part('week',now());

"and the days that are in that week" I guess want to answer a question
such as:
Given a date, what is first date in that same week, and what is the last
date in that week. There are a couple of approaches to this. My first was:

select
to_date(date_part('year',now()),'YYYY')+(7*date_part('week',now()));

and the above +6 to the the last day of the week. Another approach for
this same question is much simplier (if the question is indeed what you
are asking)

select now()-date_part('dow',now());

This last select gives the Sunday for the current week. To get the
Saturday, simply:

select now()-date_part('dow',now())+6;

Of course, replace the now() with whatever contains the date or timestamp.

John McKown

> I'm probably staring right at it. (One of the difficulties with RTFMing, is
> having too many docs!)
> 
> Is there anything in the API that produces the week of the year, from 1 to
> 52 or 53 depending on the week of the year, and the days that are in that
> week?
> 
> Many thanks.
> 
>                                           -dlj.
> 
> 
>