The T-SQL SwitchOffSet is an date function and returns a datetimeoffset value that is changed from the stored time zone offset.

SwitchOffSet Syntax:

SWITCHOFFSET( DATETIMEOFFSET, timezone )

SwitchOffSet Example:

select switchoffset (CONVERT(datetimeoffset, GETDATE()), '-03:00') AS Result_1,
switchoffset (CONVERT(datetimeoffset, GETDATE()), '+03:00') AS Result_2;