Re: Postgresql date bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Postgresql date bug
Date
Msg-id 26726.987783344@sss.pgh.pa.us
Whole thread Raw
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Date Representation Bug. Timezone and update on an already posted as #208 reportbug
Next
From: jmitchell@greatbridge.com
Date:
Subject: pg_ctl restart bug