Horje
sql server utc to local Code Example
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]
Source: stackoverflow.com



Sql

Related
force using index plsql Code Example force using index plsql Code Example
index using in query plsql Code Example index using in query plsql Code Example
flask sqlalchemy boolean field Code Example flask sqlalchemy boolean field Code Example
postgres in operator with comma separated values Code Example postgres in operator with comma separated values Code Example
mysql increment value by 1 in update Code Example mysql increment value by 1 in update Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje