> 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.
In response to
pgsql-bugs by date
|Next:||From: Phil Steinke||Date: 2001-04-09 22:30:17|
|Subject: Re: date_part returns wrong day for 1974-04-28|
|Previous:||From: pgsql-bugs||Date: 2001-04-09 18:21:11|
|Subject: date_part returns wrong day for 1974-04-28|