Time Change from Chicago to Los Angeles : NEW_TIME « Date Timezone « Oracle PL / SQL






Time Change from Chicago to Los Angeles

 
SQL> SELECT TO_CHAR(NEW_TIME(TO_DATE('060299 01:00:00 AM',
  2            'MMDDYY HH:MI:SS AM'),
  3            'CDT','PDT'), 'DD-MON-YY HH:MI:SS AM') "Central to Pacific"
  4       from DUAL;
Central to Pacific
---------------------
01-JUN-99 11:00:00 PM

1 row selected.

SQL>
SQL> --

 








Related examples in the same category

1.NEW_TIME(): Converting a Datetime from One Time Zone to Another
2.NEW_TIME() returns the equivalent of the date.