Re: Extract (week from date ) bug.

From: David Johnston <polobo(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Extract (week from date ) bug.
Date: 2013-10-30 20:43:57
Message-ID: 1383165837967-5776440.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeevan Chalke 2013-10-31 05:20:58 Re: surprising to_timestamp behavior
Previous Message Ubold Hooper 2013-10-30 19:46:35 Extract (week from date ) bug.