sql server utc to local
snippet in sql

convert utc to est sql

user9118

select CONVERT(datetime, SWITCHOFFSET(dateTimeField, DATEPART(TZOFFSET, 
dateTimeField AT TIME ZONE 'Eastern Standard Time')))

sql server utc to local

user941

SELECT
	['TIME COLUM TO CONVERT'] AS [UTC_TIME],
	DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()),['TIME COLUM TO CONVERT']) AS [lOCAL_TIME]
FROM ['TABLE NAME']

tsql utf to local time

user4622

select 
 [MyUtcDate] + getdate() - getutcdate()
from [dbo].[mytable]