SQL Server本地时间和UTC时间的相互转换实现代码

复制代码 代码如下:

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