NEW_TIME(): Converting a Datetime from One Time Zone to Another : NEW_TIME « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. NEW_TIME

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


SQL>
SQL> --NEW_TIME(): Converting a Datetime from One Time Zone to Another
SQL>
SQL> SELECT TO_CHAR(NEW_TIME(TO_DATE('25-MAY-2006 19:45', 'DD-MON-YYYY HH24:MI'), 'PST', 'EST'), 'DD-MON-YYYY HH24:MI') FROM dual;

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

SQL>








Related examples in the same category

1.NEW_TIME() returns the equivalent of the date.
2.Time Change from Chicago to Los Angeles