/ Published in: SQL
How to convert a column of DATETIME UTC to local time.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT DATEADD(HOUR,DATEDIFF(HOUR,GETUTCDATE(),GETDATE()),[COLUMN]) AS "Column" FROM [TABLE]