Answers for "how to get utc local time sql"

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 "how to get utc local time sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to get utc local time sql"

Code answers related to "how to get utc local time sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to get utc local time sql"

Code answers related to "how to get utc local time sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us