Re: getting weekly total based on daily...
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.
Import Notes
Reply to msg id not found: 200301271652.50521.jerome@gmanmi.tvReference msg id not found: 200301271652.50521.jerome@gmanmi.tv
but this gives me week on year not week of month...
:)
Show quoted text
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.