NEW_TIME converts the date and time from one time zone to another. Before using this function, set the NLS_DATE_FORMAT parameter to display 24-hour time.
DATE
NEW_TIME(date, timezone1, timezone2)
date is a datetime expression to be converted to a new time zone.
timezone1 is the time zone of date.
timezone2 is the new time zone.
The time zone arguments are limited to the values inTable 3-2. For other time zones, use FROM_TZ.
| Time Zone | Abbreviation |
|---|---|
|
Alaska-Hawaii Daylight Time |
HDT |
|
Alaska-Hawaii Standard Time |
HST |
|
Atlantic Daylight Time |
ADT |
|
Atlantic Standard Time |
AST |
|
Bering Daylight Time |
BDT |
|
Bering Standard Time |
BST |
|
Central Daylight Time |
CDT |
|
Central Standard Time |
CST |
|
Eastern Daylight Time |
EDT |
|
Eastern Standard Time |
EST |
|
Greenwich Mean Time |
GMT |
|
Mountain Daylight Time |
MDT |
|
Mountain Standard Time |
MST |
|
Newfoundland Standard Time |
NST |
|
Pacific Daylight Time |
PDT |
|
Pacific Standard Time |
PST |
|
Yukon Daylight Time |
YDT |
|
Yukon Standard Time |
YST |
NEW_TIME(SYSDATE, 'PST', 'EST') returns a value such as 18-JAN-07 04:38:07 in Eastern Standard Time when SYSDATE is 18-JAN-07 01:38:07 in Pacific Standard Time. For this example, NLS_DATE_FORMAT is set to DD-MON-RR HH:MI:SS.