Roman wrote:
>
> I see in the doc: ( however it does not explain the case )
>
> week
> The number of the week of the year that the day is in. By definition (ISO
> 8601), the first week of a year contains January 4 of that year. (The
> ISO-8601 week starts on Monday.) In other words, the first Thursday of a
> year is in week 1 of that year. (for timestamp values only)
>
It's actually in the doc for the to_char() function. 'WW' uses a week
definition where January 1st is in week 1. If you use 'IW', you get
the ISO definition.
=> select to_char(now(),'yyyyIW');
to_char
---------
200804
(1 row)
=> select extract(week from now());
date_part
-----------
4
--Magne
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
