NEW_TIME
NEW_TIME (date,z1,z2)
Converts a datetime value date from time zone z1 to a date/time value in time zone z2. Time zones must be chosen from the time zone identifiers listed in Table 8-2. Note that There is no relation between these identifiers and the TZD and TZR format elements used for time zones in the timestamp values introduced in Oracle9i.
Table 8-2. Time zone identifiers
|
Time zone identifier |
Time zone |
|---|---|
|
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 |