| Lists: | pgsql-bugs |
|---|
| From: | Ubold Hooper <uhooper(at)amplify(dot)com> |
|---|---|
| To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Extract (week from date ) bug. |
| Date: | 2013-10-30 19:46:35 |
| Message-ID: | 375B948D2EECB74DBF35610C8581471A7024F8@WgExch09.wgenhq.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
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|Email: uhooper(at)amplify(dot)com<mailto:uhooper(at)amplify(dot)com>
| 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 |
| 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.