Answers for "store utc date in sql server"

sql server get utc date

GETUTCDATE()

Posted by: Guest on March-10-2020

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 "store utc date in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "store utc date in sql server"

Code answers related to "store utc date in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "store utc date in sql server"

Code answers related to "store utc date in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us