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
thatthe day is in. By definition (ISO> 8601), the first week of a year contains January 4 of that year. (The> ISO-8601
weekstarts 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