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

-2 votes143 views3 answers
Oracle tablespace usage
SQL
5 votes173 views1 answer
How to get all table names in sql query
SQL
0 vote160 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote160 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
5 votes140 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote142 views1 answer
Events not working db
SQL
0 vote167 views1 answer
Python sqlalchemy connection show server
SQL
0 vote163 views2 answers
Collation in sql
SQL
1 vote139 views1 answer
Can not connect to mysql server
SQL
0 vote161 views1 answer
Google cloud sql postgres url example
SQL