DATETIME Convert UTC to Local - SQL Snipplr Social Repository

Revision: 41065

at February 11, 2011 09:59 by davidrodriguez

Initial Code

SELECT DATEADD(hour,DATEDIFF(hour,GETUTCDATE(),GETDATE()),[Column]) AS "Column" FROM [Table]

Initial URL

Initial Description

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

Initial Title

DATETIME Convert UTC to Local

Initial Tags

Initial Language

SQL