Thanks to this StackOverflow answer:
CONVERT( DATETIME, SWITCHOFFSET( CONVERT(DATETIMEOFFSET, MyTable.UtcColumn), DATENAME(TzOffset, SYSDATETIMEOFFSET()) ) ) AS ColumnInLocalTime
60 second software development tutorials and demos, and short blog posts.
60 second software development tutorials and demos, and short blog posts.