Hello,
Can someone please stop me from going mad? I am unable to convert this date format to correct value:
1. Why is it displaying AM despite data is PM?
select to_timestamp_tz(substr('30-MAR-16 02.48.52.629000000 PM AMERICA/CHICAGO',0,20),'DD/MM/YY HH24:MI:SS TZH:TZM') as date_inserted from dual;
----------------------------------------------------------
30-MAR-16 02.48.52.000000000 AM +06:00
select NEW_TIME ((to_timestamp_tz(substr('30-MAR-16 02.48.52.629000000 PM AMERICA/CHICAGO',0,18),'DD/MM/YY HH24:MI:SS')), 'GMT', 'CDT') as date_inserted from dual;
-----------------------------------------------------------
3/30/16 2:48 AM
Please advise.