Re: Postgresql date bug

Started by Tom Lanealmost 25 years ago1 messagesbugs
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

"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