Postgres Pro
Downloads
Home   >   mailing lists

Extract (week from date ) bug. - Mailing list pgsql-bugs

From Ubold Hooper
Subject Extract (week from date ) bug.
Date
Msg-id 375B948D2EECB74DBF35610C8581471A7024F8@WgExch09.wgenhq.net
Whole thread Raw
Responses Re: Extract (week from date ) bug.  (David Johnston <polobo@yahoo.com>)
List pgsql-bugs
Tree view 
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>

pgsql-bugs by date:

Previous
From: David Johnston
Date:
Subject: Re: BUG #8569: with recursive work incorrectly with function
Next
From: David Johnston
Date:
Subject: Re: Extract (week from date ) bug.