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

0 vote180 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote177 views1 answer
Limit in access query
SQL
0 vote174 views4 answers
Change schema in sql server
SQL
0 vote180 views1 answer
Postgresql import a database of gzip
SQL
0 vote169 views1 answer
Oracle last connection
SQL
2 votes179 views3 answers
Mysql list tables by size
SQL
1 vote179 views1 answer
Mysql get max value and id
SQL
0 vote186 views1 answer
How to change mysql port in xampp
SQL
0 vote174 views2 answers
Postgresql variable in query
SQL
10 votes179 views1 answer
Oracle dependencies table
SQL