调用NEW_TIME将日期和时间从时区转换到另外时区_云原生数据库 PolarDB(PolarDB)-阿里云帮助中心

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