advanced code snippet search

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.

Expand | Embed | Plain Text 
  1. SELECT DATEADD(hour,DATEDIFF(hour,GETUTCDATE(),GETDATE()),[COLUMN]) AS "Column" FROM [TABLE]

Report this snippet  

You need to login to post a comment.