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 vote226 views2 answers
Full join
SQL
5 votes197 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
1 vote222 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote195 views1 answer
Postgresql print variable
SQL
1 vote212 views1 answer
Add multiple row table pl sql
SQL
0 vote218 views3 answers
Postgres date difference seconds
SQL
2 votes198 views1 answer
Columns Present in a table
SQL
0 vote199 views1 answer
How to change mysql port in xampp
SQL
0 vote177 views1 answer
Rabbitmq service not starting
SQL
3 votes195 views1 answer
Set default today mysql
SQL