Re: getting weekly total based on daily...

but this gives me week on year not week of month...

:)

On Monday 27 January 2003 11:31, you wrote:
> On Mon, Jan 27, 2003 at 16:52:50 +0800,
>
>   jerome <jerome@gmanmi.tv> wrote:
> > i was wondering is there a built-in funtion that gets the weeknumber
> > based on date..
>
> area=> select extract(week from current_date);
>  date_part
> -----------
>          4
> (1 row)
>
> This is the ISO week of the year. Week 1 is the week containing the first
> Thursday of the year. Weeks go from Monday to Sunday.