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 not supported auth mode
SQL
37 votes281 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
3 votes289 views6 answers
Jwt laravel
SQL
0 vote278 views1 answer
Mysql workbench format date
SQL
1 vote262 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote259 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote296 views1 answer
Sql pivot without aggregate
SQL
1 vote236 views1 answer
Psql show with user is logged in
SQL
1 vote273 views1 answer
Change old domain to new domain name wordpress
SQL
-1 vote253 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL