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 vote211 views2 answers
Postgresql check privileges on schema
SQL
0 vote190 views1 answer
Postgresql create table many-to-many
SQL
1 vote201 views1 answer
Sqlalchemy order by descending
SQL
2 votes196 views1 answer
Oracle apex list connected users
SQL
0 vote184 views1 answer
Get records in sql according to month name and count
SQL
1 vote210 views1 answer
Db.Database.SqlQuery
SQL
0 vote282 views1 answer
ORA-01400
SQL
0 vote324 views1 answer
Setting default value for Boolean data type in SQL
SQL
2 votes244 views5 answers
Install postgresql 10 centos 7
SQL
52 votes849 views6 answers
Rename column sql
SQL