I converted a table's
DateTime
DateTimeOffset
You can use SWITCHOFFSET
to change the offset. You will need to subtract the amount of hours though from the date if you don't want the date to change.
SELECT SWITCHOFFSET(DATEADD(hh, -1, CAST (GETDATE() AS DATETIMEOFFSET)),
'+01:00')