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 vote221 views1 answer
Sql server concat null
SQL
7 votes242 views4 answers
Index in mysql
SQL
0 vote222 views1 answer
Get who is hired in month in sql
SQL
0 vote221 views1 answer
Oracle gather table statistics
SQL
4 votes226 views1 answer
Mysql delete last row
SQL
1 vote233 views1 answer
Oracle sequence last_number
SQL
1 vote231 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
3 votes230 views2 answers
See mysql users ubuntu
SQL
0 vote209 views1 answer
Remove default constraint sql server
SQL
0 vote207 views1 answer
Backup a table in sql
SQL