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

Thomas Lockhart <lockhart@alumni.caltech.edu>

From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: lintec@clarkhall.ca, pgsql-bugs@postgresql.org
Date: 2001-04-09T20:40:47Z
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