Thread: Extract (week from date ) bug.
I think there must be a bug in the date calculations. Consider the following query select extract(week from date('2010-12-31')), extract(week from date('2011= -01-01')), extract(week from date('2011-01-03')) Result: date_part date_part date_part 52 52 1 Why is extract(week from date('2011-01-01')) not identified as week 1? -- Ubold Hooper Amplify Insight| 55 Washington St. Brooklyn, NY. 11201|Tel: 347-474-4829|Em= ail: uhooper@amplify.com<mailto:uhooper@amplify.com>
Ubold Hooper wrote > Why is extract(week from date('2011-01-01')) not identified as week 1? Because "week" uses the ISO calendar and Week 1, 2011 begins on Monday, January 3rd. http://www.postgresql.org/docs/9.3/interactive/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Extract-week-from-date-bug-tp5776436p5776440.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.