Posted By

davidrodriguez on 02/11/11


Tagged

mssql


Versions (?)

DATETIME Convert UTC to Local


 / Published in: SQL
 

How to convert a column of DATETIME UTC to local time.

  1. SELECT DATEADD(hour,DATEDIFF(hour,GETUTCDATE(),GETDATE()),[COLUMN]) AS "Column" FROM [TABLE]

Report this snippet  

You need to login to post a comment.