NEW_TIME function
The new_time function converts a date in time zone1 to a date in time zone2.
The syntax for the new_time function is:
new_time( date, zone1, zone2 )| zone1 and zone2 Value | Description |
|---|---|
| AST | Atlantic Standard Time |
| ADT | Atlantic Daylight Time |
| BST | Bering Standard Time |
| BDT | Bering Daylight Time |
| CST | Central Standard Time |
| CDT | Central Daylight Time |
| EST | Eastern Standard Time |
| EDT | Eastern Daylight Time |
| GMT | Greenwich Mean Time |
| HST | Alaska-Hawaii Standard Time |
| HDT | Alaska-Hawaii Daylight Time |
| MST | Mountain Standard Time |
| MDT | Mountain Daylight Time |
| NST | Newfoundland Standard Time |
| PST | Pacific Standard Time |
| PDT | Pacific Daylight Time |
| YST | Yukon Standard Time |
| YDT | Yukon Daylight Time |
SQL> select new_time (to_date ('2012/12/01 01:45', 'yyyy/mm/dd HH24:MI'), 'AST', 'MST') from dual;
NEW_TIME(
---------
30-NOV-12
SQL>