NEW_TIME

函数NEW_TIME用于将一个日期和时间值从一个时区转换到另外一个时区。

这个函数返回值类型为DATE。语法如下:

NEW_TIME(DATE, time_zone1, time_zone2)

其中参数time_zone1和time_zone2必须是从下面列表中列Time Zone中取出的字符串类型值。

Time Zone

Offset from UTC

Description

AST

UTC+4

Atlantic Standard Time

ADT

UTC+3

Atlantic Daylight Time

BST

UTC+11

Bering Standard Time

BDT

UTC+10

Bering Daylight Time

CST

UTC+6

Central Standard Time

CDT

UTC+5

Central Daylight Time

EST

UTC+5

Eastern Standard Time

EDT

UTC+4

Eastern Daylight Time

GMT

UTC

Greenwich Mean Time

HST

UTC+10

Alaska-Hawaii Standard Time

HDT

UTC+9

Alaska-Hawaii Daylight Time

MST

UTC+7

Mountain Standard Time

MDT

UTC+6

Mountain Daylight Time

NST

UTC+3:30

Newfoundland Standard Time

PST

UTC+8

Pacific Standard Time

PDT

UTC+7

Pacific Daylight Time

YST

UTC+9

Yukon Standard Time

YDT

UTC+8

Yukon Daylight Time

下面是一个关于函数NEW_TIME的示例:

SELECT NEW_TIME(TO_DATE('08-13-07 10:35:15','MM-DD-YY HH24:MI:SS'),'AST', 'PST') "Pacific Standard Time" FROM DUAL;

Pacific Standard Time
---------------------  
 13-AUG-07 06:35:15
(1 row)