UTC时间转换为本地时间

最新推荐文章于 2021-02-16 10:08:56 发布

weixin_30622181

最新推荐文章于 2021-02-16 10:08:56 发布

阅读量77

点赞数

原文链接：http://www.cnblogs.com/armanda/p/4836291.html

版权

UTC时间转换为本地时间
DATEADD(hour, DATEDIFF(hour,GETUTCDATE(),GETDATE()), OrderDate) <'2015-02-02'

DECLARE @LocalDate DATETIME,
@UTCDate DATETIME,
@LocalDate2 DATETIME

SET @LocalDate = GETDATE()
SET @UTCDate = DATEADD(hour, DATEDIFF(hour,GETDATE(),GETUTCDATE()), @LocalDate)
SET @LocalDate2 = DATEADD(hour, DATEDIFF(hour,GETUTCDATE(),GETDATE()), @UTCDate)

SELECT '1. Now' [Now], @LocalDate [DateTime]
UNION
SELECT '2. UTC', @UTCDate
UNION
SELECT '3. Now again', @LocalDate2

转载于:https://www.cnblogs.com/armanda/p/4836291.html