How to set the timeoffset in a Datetimeoffset column without changing the date part
To avoid the extra DateAdd (may be difficult if time zone is a variable), use:

TODATETIMEOFFSET(@datetimeoffset, @timeZone)