Andrea Allred notes that there’s now a time zone system table, as of SQL Server 2016:
Yes, it is 132 rows of magic! Now that we have this super cool table, how do we use it? Let’s pretend that my data is time-stamped in US Mountain Standard Time, but I want to display it in Western Australia Standard Time.
Read on for table details.