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 vote301 views2 answers
Find Overlapping sql
SQL
0 vote337 views1 answer
Mysql random number between 1 and 100
SQL
1 vote314 views1 answer
Set autoincrement to 0
SQL
2 votes305 views1 answer
Enum in SQL Server
SQL
0 vote307 views1 answer
How to avoid duplicate records in sqlite
SQL
2 votes324 views3 answers
Copy data from one table column to another table column in sql
SQL
4 votes325 views2 answers
REST API
SQL
0 vote305 views1 answer
Postgres call view
SQL
0 vote335 views1 answer
View t-sql mail configuration
SQL
0 vote325 views2 answers
Oracle sql for each row
SQL