Re: Difference in TO_TIMESTAMP results.

On Tue, Sep 18, 2018 at 8:44 AM Prabhat Sahu
<prabhat(dot)sahu(at)enterprisedb(dot)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