Re: BUG #13848: 2016 Week Number Error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #13848: 2016 Week Number Error
Date
Msg-id 13212.1452192028@sss.pgh.pa.us
Whole thread Raw
In response to BUG #13848: 2016 Week Number Error  (maxk@yelp.com)
List pgsql-bugs
maxk@yelp.com writes:
> SELECT EXTRACT(Week FROM current_date) = 1 instead of 2 Week numbers are all
> off

Not a bug.  See the manual's definition of this field:

: The number of the ISO 8601 week-numbering week of the year. By
: definition, ISO weeks start on Mondays and the first week of a year
: contains January 4 of that year. In other words, the first Thursday of a
: year is in week 1 of that year.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: BUG #13848: 2016 Week Number Error
Next
From: John R Pierce
Date:
Subject: Re: BUG #13853: initdb to UNC path