NEW_TIME

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.

Return Value

DATE

Syntax

NEW_TIME(date, timezone1, timezone2)

Arguments

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 timezone arguments are limited to the values in the following table. For other timezones, use FROM_TZ.

Abbreviation	Time Zone
ADT	Atlantic Daylight Time
AST	Atlantic Standard Time
BDT	Bering Daylight Time
BST	Bering Standard Time
CDT	Central Daylight Time
CST	Central Standard Time
EDT	Eastern Daylight Time
EST	Eastern Standard Time
GMT	Greenwich Mean Time
HDT	Alaska-Hawaii Daylight Time
HST	Alaska-Hawaii Standard Time
MDT	Mountain Daylight Time
MST	Mountain Standard Time
NST	Newfoundland Standard Time
PDT	Pacific Daylight Time
PST	Pacific Standard Time
YDT	Yukon Daylight Time
YST	Yukon Standard Time

Example

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.