The following example returns an Atlantic Standard time,
given the Pacific Standard time equivalent:
ALTER SESSION SET NLS_DATE_FORMAT = ’DD-MON-YYYY HH24:MI:SS’;
SELECT NEW_TIME(TO_DATE(
’11-10-99 01:23:45’, ’MM-DD-YY HH24:MI:SS’),
’AST’, ’PST’) "New Date and Time" FROM DUAL;
New Date and Time
--------------------
09-NOV-1999 21:23:45