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