Oracle in a Nutshell

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