Hello
our customer reports different result of to_timestamp function between
8.3 and 8.4
It looks like to_timestamp returns some strange timezone value
postgres=# select to_timestamp('00:00:00','HH24:MI:SS');
to_timestamp
─────────────────────────────────
0001-01-01 00:00:00+00:57:44 BC
(1 row)
postgres=# select to_timestamp('1.2.2009 20:10:10','DD.MM.YYYY HH24:MI:SS');
to_timestamp
────────────────────────
2009-02-01 20:10:10+01
(1 row)
8.3 returns +01
it
we missing 2 minutes, 15 second
any explanation?
Regards
Pavel Stehule
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
