Convert UTC to local time in SQL Server

 Thanks to this StackOverflow answer:

convert(
    datetime, 
    switchoffset(
        convert(datetimeoffset, MyTable.UtcColumn), 
        datename(TzOffset, sysdatetimeoffset())
    )
) as ColumnInLocalTime