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

20 votes318 views4 answers
Reset auto increment in MySQL
SQL
0 vote351 views1 answer
How to map sql column to custom names
SQL
1 vote276 views1 answer
Mysql see column types
SQL
1 vote323 views1 answer
Order by oracle
SQL
0 vote367 views1 answer
Check constraint is violated
SQL
0 vote340 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote325 views1 answer
Dump db only triggers mysql
SQL
4 votes331 views1 answer
Search column by name mysql
SQL
0 vote321 views1 answer
Drop unique
SQL
0 vote316 views1 answer
Sql search all columns of database oracle sql
SQL