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

13 votes316 views2 answers
Sql online compiler
SQL
11 votes325 views2 answers
Mysql disable safe mode
SQL
7 votes379 views2 answers
Drop index oracle
SQL
6 votes303 views5 answers
Alter table oracle
SQL
0 vote300 views1 answer
Opensuse stop MySQL
SQL
0 vote271 views1 answer
Mysql does collate nopad recognize space
SQL
1 vote292 views1 answer
Set statistics on in ssms
SQL
0 vote304 views1 answer
Addition of 2 column value in mysql
SQL
0 vote374 views1 answer
Plpgsql create function
SQL
2 votes296 views1 answer
Mysql time ago difference
SQL