| From: | Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Difference in TO_TIMESTAMP results. |
| Date: | 2018-09-18 05:43:47 |
| Message-ID: | CANEvxPoUx7gB01isJ53PzsgSJMbAHbXqRhPqqvJ9gXF=RfUhRA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | amul sul | 2018-09-18 05:49:44 | Re: Multiple primary key on partition table? |
| Previous Message | Rajkumar Raghuwanshi | 2018-09-18 05:31:26 | Re: Getting ERROR: could not open file "base/13164/t3_16388" with partition table with ON COMMIT |