Code for mutual conversion between SQL Server local time and UTC time

Code for converting the local time and UTC time of SQLServer. For more information, see.

Code for converting the local time and UTC time of SQL Server. For more information, see.

The Code is as follows:
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