https://learn.microsoft.com/en-us/sql/t-sql/functions/switchoffset-transact-sql?view=sql-server-ver15
SWITCHOFFSET (Transact-SQL) - SQL Server | Microsoft Learn
SWITCHOFFSET returns a datetimeoffset value that is changed from the stored time zone offset to a specified new time zone offset.
sql servertransactmicrosoftlearn