sql server convert local time to utc code example
Example: sql server utc to local
SELECT
['TIME COLUM TO CONVERT'] AS [UTC_TIME],
DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()),['TIME COLUM TO CONVERT']) AS [lOCAL_TIME]
FROM ['TABLE NAME']
SELECT
['TIME COLUM TO CONVERT'] AS [UTC_TIME],
DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()),['TIME COLUM TO CONVERT']) AS [lOCAL_TIME]
FROM ['TABLE NAME']