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

11 votes131 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote117 views2 answers
How to get json data mysql
SQL
0 vote143 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
15 votes153 views4 answers
Sql update from select
SQL
0 vote123 views1 answer
Sql server port 1434
SQL
-1 vote130 views3 answers
Psql get last rows
SQL
0 vote124 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote125 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote136 views1 answer
Oracle list user locked
SQL
5 votes133 views1 answer
Commentaire table oracle
SQL