Sql server utc to local

Convert utc to est sql

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

Source: stackoverflow.com

Sql server utc to local

SELECT
	['TIME COLUM TO CONVERT'] AS [UTC_TIME],
	DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()),['TIME COLUM TO CONVERT']) AS [lOCAL_TIME]
FROM ['TABLE NAME']

Tsql utf to local time

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

-2

Source: stackoverflow.com

Similar codes

31 votes200 views4 answers
How to get duplicate records with multiple field in sql
SQL
1 vote185 views1 answer
How to delete record sql delphi
SQL
3 votes222 views5 answers
Duplicate table sql
SQL
3 votes193 views3 answers
How to add month in update sql
SQL
32 votes189 views6 answers
Insert select
SQL
0 vote208 views1 answer
Oracle pl/sql check if file exists
SQL
5 votes205 views1 answer
Sql table columns
SQL
0 vote185 views1 answer
Postgres week number
SQL
0 vote194 views4 answers
User defined function sql
SQL
20 votes196 views3 answers
Update values in select statement sql
SQL