函数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)