SQL: Convert UTC Time to Local Time

11/25/2014 - 10:28 PM

[InstallTimeToLocalTime] = CONVERT(datetime, SWITCHOFFSET(CONVERT(datetimeoffset, [UTCInstallTime]), DATENAME(TzOffset, SYSDATETIMEOFFSET())))

Cacher is the code snippet organizer for pro developers