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.