Re: different result between 8.3 and 8.5 (to_timestamp function)

Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> 2009/11/16 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>> What timezone setting are you using? I'd bet a great deal that
>> +00:57:44 is what the Olsen database shows as the LMT offset for
>> your zone before standardized timezones were adopted.

> I am using CET.

"CET" covers a multitude of sins, but I suspect it's specifically
Europe/Prague:

# Zone NAME GMTOFF RULES FORMAT [UNTIL]
Zone Europe/Prague 0:57:44 - LMT 1850
0:57:44 - PMT 1891 Oct # Prague Mean Time
1:00 C-Eur CE%sT 1944 Sep 17 2:00s
1:00 Czech CE%sT 1979
1:00 EU CE%sT

So midnight local time corresponds to 00:57:44 GMT before 1891.
If you think this is wrong, use another zone, or take it up with
the zic folk.

regards, tom lane