Hi All,
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 ?
--
With Regards,
Prabhat Kumar Sahu
Skype ID: prabhat.sahu1984
EnterpriseDB Corporation
The Postgres Database Company
