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

8 votes129 views6 answers
Sql insert
SQL
2 votes134 views1 answer
Pdo mysql insert
SQL
0 vote120 views1 answer
Partitioning in oracle-base
SQL
7 votes139 views1 answer
Query delete duplicates
SQL
0 vote128 views1 answer
Intellij mysql set timezone
SQL
0 vote84 views1 answer
How to set field to null in sql
SQL
0 vote146 views2 answers
Collation in sql
SQL
0 vote129 views1 answer
Show size of all tables postgres
SQL
0 vote144 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote122 views1 answer
Report in database
SQL