Determine if daylight saving time is active? SQL Server

Question

I have a table with users, UTC time offset, and if they observe daylight saving time. Is there a built in way to get the correct user time?

Answer 1

The sys.time_zone_info table introduced in SQL 2016 allows to determine the offset from UTC and whether DST is currently in effect.

SELECT * FROM sys.time_zone_info

The query result will be: