different result between 8.3 and 8.5 (to_timestamp function)

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: different result between 8.3 and 8.5 (to_timestamp function)
Date: 2009-11-16 14:47:00
Message-ID: 162867790911160647s74a7c66fl1593584c383339d6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-11-16 15:00:47 Re: ORDER BY vs. volatile functions
Previous Message Andrew Chernow 2009-11-16 14:35:16 Re: Listen / Notify - what to do when the queue is full