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

1 vote256 views1 answer
Mysql best tutorial for beginners
SQL
0 vote256 views1 answer
Mysql update even / odd rows
SQL
0 vote267 views1 answer
Sql common columns
SQL
0 vote245 views1 answer
Mysql page segment
SQL
0 vote279 views1 answer
Mysql add to number
SQL
0 vote271 views1 answer
Drop-toys-table
SQL
3 votes257 views3 answers
C# sql select
SQL
0 vote237 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote269 views1 answer
Sql where part of string match
SQL
0 vote213 views1 answer
How to see the content of tables in pgadmin
SQL