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