I believe the issue you are running into is that SYSDATETIMEOFFSET() is not Daylight Savings Time aware.

How you handle the difference depends on numerous things (what you are doing with what data with what time zones blah blah)

Sue