SET
@UTCDate = DATEADD(
hour
, DATEDIFF(
hour
,GETDATE(),GETUTCDATE()), @LocalDate)
SET
@LocalDate2 = DATEADD(
hour
, DATEDIFF(
hour
,GETUTCDATE(),GETDATE()), @UTCDate)
SET
@UTCDate = DATEADD(
hour
, DATEDIFF(
hour
,GETDATE(),GETUTCDATE()), @LocalDate)
SET
@LocalDate2 = DATEADD(
hour
, DATEDIFF(
hour
,GETUTCDATE(),GETDATE()), @UTCDate)
原文:https://www.cnblogs.com/johnblogs/p/8436387.html