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)