Re: Postgresql date bug

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgresql date bug
Дата
Msg-id 26726.987783344@sss.pgh.pa.us
обсуждение исходный текст
Список pgsql-bugs
"g.pesce@hotbrain.it" <gpesce@tiscalinet.it> writes:
> if I insert with
> insert into pippo values ('22/05/1977 01:00:00');
> all goes ok.
> with
> insert into pippo values ('22/05/1977 00:59:00');
> the result is wrong! Is it related with daylight saving time?

Possibly, but why just those dates?  AFAICT those are not DST
transition days in MET zone (correct?) so I don't see why they'd
be affected and not other days.

Can anyone else reproduce this?  I don't see it happening on my
machines, either in 7.0.* or 7.1.  I think there must be some
platform dependency involved.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Date Representation Bug. Timezone and update on an already posted as #208 reportbug
Следующее
От: jmitchell@greatbridge.com
Дата:
Сообщение: pg_ctl restart bug