Time Change from Chicago to Los Angeles : NEW_TIME « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. NEW_TIME
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

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