AT TIME ZONE – SQL Server 2016
The other day I was required to find out more about offsets and timezones and I came across a new T-SQL function in SQL Server 2016 AT TIME ZONE. This function gives us the current offset in the target time zone.
sqltomato
One of your five a day