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 vote357 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote351 views1 answer
Mysql change timestamp on update
SQL
0 vote415 views1 answer
Alternative for LIMIT sql
SQL
0 vote369 views2 answers
Sql last updated
SQL
0 vote382 views1 answer
Pgadmin check database
SQL
0 vote350 views1 answer
Dump db only triggers mysql
SQL
0 vote345 views1 answer
Sql server port 1434
SQL
4 votes334 views1 answer
Postgresql show current database
SQL
0 vote338 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote353 views1 answer
Select 1 from orders
SQL