Question : convert utc to est sql
Answered by : illuzio
select CONVERT(datetime, SWITCHOFFSET(dateTimeField, DATEPART(TZOFFSET,
dateTimeField AT TIME ZONE 'Eastern Standard Time')))
Source : https://stackoverflow.com/questions/8038744/convert-datetime-column-from-utc-to-local-time-in-select-statement | Last Update : Sat, 28 Mar 20
Question : tsql utf to local time
Answered by : annoying-ape-v5wuo37ioeuh
select [MyUtcDate] + getdate() - getutcdate()
from [dbo].[mytable]
Source : https://stackoverflow.com/questions/8038744/convert-datetime-column-from-utc-to-local-time-in-select-statement | Last Update : Mon, 22 Jun 20