> 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