Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Converting a Datetime from One Time Zone to Another with NEW_TIME() function

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>