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