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 vote345 views1 answer
How to fix mysql stop unexpectedly
SQL
4 votes328 views2 answers
DB::transaction
SQL
2 votes375 views2 answers
Create empty table from existing table
SQL
0 vote339 views1 answer
Php get closest location by latitude longitude
SQL
4 votes328 views1 answer
Wilayah indonesia sql
SQL
0 vote388 views1 answer
Having all mysql
SQL
2 votes341 views1 answer
Oracle sql concatenate results into string
SQL
5 votes353 views1 answer
How to get all dates in a month in oracle
SQL
0 vote352 views1 answer
Where field is null sql knex
SQL
0 vote371 views1 answer
Mysql 3 months ago
SQL