Re: Difference in TO_TIMESTAMP results.

On Tue, Sep 18, 2018 at 8:44 AM Prabhat Sahu
<prabhat.sahu@enterprisedb.com> wrote:
>
> I have found below difference in TO_TIMESTAMP results.
>
> postgres[114552]=# select to_timestamp('15-07-1984 23:30:32','dd-mm-yyyy hh24:mi:ss');
>        to_timestamp
> ---------------------------
>  1984-07-15 23:30:32+05:30
> (1 row)
>
> postgres[114552]=# select to_timestamp('15-07-84 23:30:32','dd-mm-yyyy hh24:mi:ss');
>          to_timestamp
> ------------------------------
>  0084-07-15 23:30:32+05:53:28
> (1 row)
>
> My doubt is the ":28" in timezone part in 2nd result, is it expected ?

Hmm, that looks strange.  My first idea was that it's related to
cf984672.  But I found that same behavior existed before cf984672.
I'm going to investigate more on that.

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company