Answers for "sql server datetime utc or local"

SQL
6

sql server get utc date

GETUTCDATE()
Posted by: Guest on March-10-2020
1

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']
Posted by: Guest on December-17-2020

Code answers related to "sql server datetime utc or local"

Code answers related to "SQL"

Browse Popular Code Answers by Language