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
Thanks to this StackOverflow answer:
convert( datetime, switchoffset( convert(datetimeoffset, MyTable.UtcColumn), datename(TzOffset, sysdatetimeoffset()) ) ) as ColumnInLocalTime