否有效回复 - UTC日期AT时区 [英] No Valid replies -- UTC Date AT Time Zone
问题描述
我在中央时区。我需要将Date值转换为UTC日期。我正在尝试使用AT时区,但是当我使用AT时区时它没有取正确的结果。
I am in Central Time Zone. I need to convert Date values to UTC dates. I am trying to use AT time zone but its not fetching me correct results when I use AT Time Zone.
SELECT GETDATE()   2019-03-18 07:00:42.917
SELECT GETDATE() 2019-03-18 07:00:42.917
SELECT GETUTCDATE() 2019-03-18 12:00:42.917
$
SELECT cast(CONVERT(datetime2(0),getdate(),126)AT TIME ZONE'中欧标准时间' 时区'UTC'作为日期时间)
结果:错误
2019-03-18 06:01:01.000
SELECT GETUTCDATE() 2019-03-18 12:00:42.917
SELECT cast(CONVERT(datetime2(0), getdate(), 126) AT TIME ZONE 'Central European Standard Time' AT TIME ZONE 'UTC' as datetime)
Result : Wrong
2019-03-18 06:01:01.000
应该是+5小时 2019-03-18 12:00:42.917(我应该得到正确的结果)
It should be +5 Hours 2019-03-18 12:00:42.917 (Correct result that I was supposed to get)
sami
推荐答案
选择datediff(小时,getdate (),getutcdate())
select datediff(hour,getdate(),getutcdate())
它返回 -2在以色列和你的国家?
It returns -2 in Israel and in your country?
这篇关于否有效回复 - UTC日期AT时区的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!