Thread

Re: Postgresql date bug

Tom Lane <tgl@sss.pgh.pa.us> — 2001-04-20T16:15:44Z

"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