2009/11/16 Tom Lane <t...@sss.pgh.pa.us>: > Pavel Stehule <pavel.steh...@gmail.com> writes: >> 2009/11/16 Tom Lane <t...@sss.pgh.pa.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. >
ok - I understand. Thank you Pavel > regards, tom lane > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
