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