convert utc to est sql
snippet in sql

convert utc to est sql

user6914

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

tsql utf to local time

user9965

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