Skip site navigation (1) Skip section navigation (2)

Re: date_part returns wrong day for 1974-04-28

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: lintec(at)clarkhall(dot)ca, pgsql-bugs(at)postgresql(dot)org
Subject: Re: date_part returns wrong day for 1974-04-28
Date: 2001-04-09 20:40:47
Message-ID: 3AD21E4F.2CDB494D@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-bugs
> Short Description
> date_part returns wrong day for 1974-04-28
> Long Description
> The date_part function is returning the wrong value for the date 1974-04-28.  It seems to work with other similar dates (+/- a day, +/- a year).
> Feel free to contact me for more information.

You are likely running across a "known feature" in PostgreSQL for
versions before the almost-here v7.1. I do not know which time zone you
are running in (need that info!) but in the US Pacific Time Zone
1973-1975 have variations due to the first energy crisis resulting from
the war in the Middle East. April 28 is not a significant date in my
time zone, but may be in yours.

                        - Thomas

In response to

Responses

pgsql-bugs by date

Next:From: Phil SteinkeDate: 2001-04-09 22:30:17
Subject: Re: date_part returns wrong day for 1974-04-28
Previous:From: pgsql-bugsDate: 2001-04-09 18:21:11
Subject: date_part returns wrong day for 1974-04-28

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group