Re: Re: Problem with Dates
От | Glen and Rosanne Eustace |
---|---|
Тема | Re: Re: Problem with Dates |
Дата | |
Msg-id | 012701c087bf$a2ae2940$0101a8c0@godzone.net.nz обсуждение исходный текст |
Ответ на | Problem with Dates ("Glen and Rosanne Eustace" <agree@godzone.net.nz>) |
Ответы |
Re: Re: Problem with Dates
Re: Re: Problem with Dates Re: Re: Problem with Dates |
Список | pgsql-sql |
> Could one of you try it in 7.1 (beta3 or later)? We've changed some > details of the way daylight-savings transitions are handled in > date-to-timestamp conversions, so I think this might be fixed now. > It's worth checking anyway. I would prefer not to upgrade right at the moment, as my development system is in the middle of a migration exercise ( hence the discovery of this bug ). If some one else is running 7.1 already and can just change their timezone to New Zealand DT and report the results it would be great. > Also, what do you get from '31/12/2000'::date::timestamp? template1=# select '31/12/2000'::date::timestamp template1-# ; ?column? ------------------------2001-01-01 00:00:00+13 (1 row) template1=#
В списке pgsql-sql по дате отправления: