../E23381-01.epub /> ../E23381-01.mobi />

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 time zone arguments are limited to the values inTable 3-2. For other time zones, use FROM_TZ.

Table 3-2 Time Zones

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


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.