Time change from Chicago to Los Angeles(Central to Pacific) : Time Zone « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. Time Zone

Time change from Chicago to Los Angeles(Central to Pacific)


SQL>
SQL> -- Time change from Chicago to Los Angeles.
SQL> SELECT TO_CHAR(NEW_TIME(TO_DATE('060297 01:00:00 AM', 'MMDDYY HH:MI:SS AM'), 'CDT','PDT'), 'DD-MON-YY HH:MI:SS AM') "Central to Pacific" from DUAL;

Central to Pacific
---------------------
01-JUN-97 11:00:00 PM

SQL>








Related examples in the same category

1.Time zone name
2.Select the current time zone
3.Timestamp with local time zone as a table column
4.Obtaining Time Zone Names
5.ALTER SESSION statement sets the local time zone to Pacific Standard Time (PST)
6.TIME_ZONE to EST and get CURRENT_TIMESTAMP, LOCALTIMESTAMP, SYSTIMESTAMP