1select CONVERT(datetime, SWITCHOFFSET(dateTimeField, DATEPART(TZOFFSET,
2dateTimeField AT TIME ZONE 'Eastern Standard Time')))
1SELECT
2 ['TIME COLUM TO CONVERT'] AS [UTC_TIME],
3 DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()),['TIME COLUM TO CONVERT']) AS [lOCAL_TIME]
4FROM ['TABLE NAME']