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.