Thread: Re: Postgresql date bug

Re: Postgresql date bug

From
Tom Lane
Date:
"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