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

2 votes377 views1 answer
Where clause for child record apex
SQL
0 vote343 views1 answer
Mysql to get column name in database
SQL
11 votes394 views1 answer
Oracle insert from select
SQL
2 votes434 views1 answer
Ssh mysql port forwarding
SQL
7 votes316 views1 answer
Grant schema permissions postgres
SQL
0 vote324 views1 answer
Remove default constraint sql server
SQL
1 vote261 views1 answer
Convert money to varchar sql server
SQL
7 votes359 views2 answers
Where keyword sql
SQL
1 vote313 views1 answer
Foreign key in oracle sql developer
SQL
0 vote323 views1 answer
Increment id in mysql
SQL