Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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> --