Converting a Datetime from One Time Zone to Another with NEW_TIME() function : NEW_TIME « Date Timestamp Functions « Oracle PL/SQL Tutorial






SQL>
SQL> SELECT TO_CHAR(NEW_TIME(TO_DATE('25-MAY-2006 19:45',
  2    'DD-MON-YYYY HH24:MI'), 'PST', 'EST'), 'DD-MON-YYYY HH24:MI')
  3  FROM dual;

TO_CHAR(NEW_TIME(
-----------------
25-MAY-2006 22:45

SQL>








13.11.NEW_TIME
13.11.1.The NEW_TIME Function
13.11.2.Converting a Datetime from One Time Zone to Another with NEW_TIME() function
13.11.3.Time Change from Chicago to Los Angeles