Re: BUG #3892: Invalid week determination

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