2009/11/16 Tom Lane <t...@sss.pgh.pa.us>: > Pavel Stehule <pavel.steh...@gmail.com> writes: >> It looks like to_timestamp returns some strange timezone value > > 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. >
postgres=# select current_timestamp; now ─────────────────────────────── 2009-11-16 16:32:33.225416+01 (1 row) I am using CET. 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