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

3 votes276 views1 answer
Oracle user quota unlimited
SQL
19 votes309 views3 answers
How to change column type psql
SQL
-2 votes280 views1 answer
Modify column name in tsql
SQL
0 vote285 views1 answer
Except in sql
SQL
0 vote301 views1 answer
Postgresql auto increment not working
SQL
4 votes287 views2 answers
Mysql how to change default charset
SQL
4 votes285 views2 answers
Bulk kill mysql processlist
SQL
0 vote285 views1 answer
Sql remove last 2 digit
SQL
0 vote282 views1 answer
T-sql check if data exists
SQL
0 vote282 views1 answer
Where case insensitive like mysql
SQL