SQL query to change timezone of datetime column code example
Example 1: convert utc to est sql
select CONVERT(datetime, SWITCHOFFSET(dateTimeField, DATEPART(TZOFFSET,
dateTimeField AT TIME ZONE 'Eastern Standard Time')))
Example 2: tsql utf to local time
select
[MyUtcDate] + getdate() - getutcdate()
from [dbo].[mytable]