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