Tsql utf to local time

This article is tagged with: Tsql utf to local time and mysql

convert utc to est sql

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

tsql utf to local time

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

This article is tagged with: Tsql utf to local time and mysql