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