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