Skip Headers
Oracle® OLAP Expression Syntax Reference
Release 11.2

Part Number E23381-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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.