/ Published in: SQL
![](/img/icon_sav.png?v3)
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]
Comments
![RSS Feed for Comments RSS Icon](/images/rss.png?v3)