Re: date_part returns wrong day for 1974-04-28
| От | Thomas Lockhart |
|---|---|
| Тема | Re: date_part returns wrong day for 1974-04-28 |
| Дата | |
| Msg-id | 3AD21E4F.2CDB494D@alumni.caltech.edu обсуждение исходный текст |
| Ответ на | date_part returns wrong day for 1974-04-28 (pgsql-bugs@postgresql.org) |
| Ответы |
Re: date_part returns wrong day for 1974-04-28
|
| Список | 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
В списке pgsql-bugs по дате отправления: