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 vote241 views1 answer
Ubuntu connect to mssql database
SQL
0 vote234 views1 answer
Sql contains numeric characters
SQL
15 votes234 views2 answers
Install mysql 8 ubuntu 18.04
SQL
2 votes267 views1 answer
How to select from mssql
SQL
0 vote234 views1 answer
What is logical database schema
SQL
0 vote234 views1 answer
Oracle query archivemode
SQL
8 votes272 views2 answers
Update sql server from another table
SQL
0 vote246 views1 answer
Object of class mysqli_result could not be converted to string
SQL
3 votes231 views5 answers
Mysql get last inserted id
SQL
0 vote264 views2 answers
Postgresql variable in query
SQL