問題描述

我想根據(jù) UTC 中的日期時間計算給定時區(qū)的日期時間.

I want to calculate Datetime at given timezone based on Datetime in UTC.

我認(rèn)為我可以通過以下方式做到這一點:

I thought that I can do it with the following:

DECLARE @timeUTC DATETIME = '2019-01-01 10:00:00'

SELECT 
@timeUTC AS timeUTC,
@timeUTC AT TIME ZONE 'Central European Standard Time' as at_time_zone_offset,
CONVERT(datetime, @timeUTC AT TIME ZONE 'Central European Standard Time',1) at_timezone_convert

-- OUTPUT
---timeUTC                  |at_time_zone_offset                |at_timezone_convert
---2019-01-01 10:00:00.000  |2019-01-01 10:00:00.000 +01:00     |2019-01-01 09:00:00.000

問題是 at_timezone_convert 的結(jié)果不正確——當(dāng)在 UTC 時間是 10:00 時，那么時間 +1 是 11:00，而不是 9.

The problem is that result of at_timezone_convert is incorrect- when at UTC time is 10:00, then time +1 is 11:00, not 9.

我怎樣才能得到 2019-01-01 11:00:00.000 的結(jié)果?

How can I get the result to be 2019-01-01 11:00:00.000?

推薦答案

Zohar Peled 解釋得很好，但為了以防萬一，這里是一個代碼示例:

Zohar Peled explained it just fine, but just in case, here is a code example:

DECLARE @timeUTC DATETIME = '2019-01-01 10:00:00';

SELECT
    @timeUTC AS timeUTC,
    @timeUTC AT TIME ZONE 'Central European Standard Time' as at_time_zone_offset,
    CONVERT(datetime, cast (@timeUTC AT TIME ZONE 'Central European Standard Time' as datetimeoffset),1) at_timezone_convert,
    CAST(CAST(@timeUTC AS datetimeoffset) AT TIME ZONE 'Central European Standard Time' AS datetime) AS ResultYouNeeded;

這篇關(guān)于從UTC時間計算特定時區(qū)的時間的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！