UTC时间转换为本地时间

时间：2021-11-05 16:41:20

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

相关文章

