Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
使用指定的时区偏移将 TIMESTAMP 值转换为 TIME STAMP WITH TIME ZONE 值。
TODATETIMEOFFSET( timestamp-expression, time-zone-offset )
timestamp-expression 要转换的 TIMESTAMP 表达式。
time-zone-offset 时区偏移。该值可以是表示 UTC 前后分钟数的 INTEGER、{ + | - } hh:nn 形式的 VARCHAR 字符串或表示 Zulu 时区的字符串 "Z"。Zulu 时区是与 UTC 相同的时区。
TIMESTAMP WITH TIME ZONE
SQL/2008 服务商扩充。
以下示例将 TIMESTAMP 值转换为 TIMESTAMP WITH TIME ZONE 值。
SELECT CAST('2009-04-03 14:45:12.123' AS TIMESTAMP) AS orig, TODATETIMEOFFSET (orig,'+11:00');
语法