Answers for "SQL query to change timezone of datetime column"

SQL
6

convert utc to est sql

select CONVERT(datetime, SWITCHOFFSET(dateTimeField, DATEPART(TZOFFSET, 
dateTimeField AT TIME ZONE 'Eastern Standard Time')))
Posted by: Guest on March-21-2020
-2

tsql utf to local time

select 
 [MyUtcDate] + getdate() - getutcdate()
from [dbo].[mytable]
Posted by: Guest on June-15-2020

Code answers related to "SQL query to change timezone of datetime column"

Code answers related to "SQL"

Browse Popular Code Answers by Language