SELECT CAST('2007-05-08 12:35:29.1234567 +12:15' AS datetimeoffset(3)) AS 'datetimeoffset'
,DATEPART(tz,CAST('2007-05-08 12:35:29.1234567 +12:15' AS datetimeoffset(3))) AS 'timezoneoffset'
,TODATETIMEOFFSET(CAST('2007-05-08 12:35:29.1234567' as datetimeoffset(3)), 735) as rebuilt
| datetimeoffset
What we started with and want to end with. | timezoneoffset
What the DatePart extracted from the original datetimeoffset | rebuilt
What happened when we put the original date back in, without the timezone, but added the timezone later. |
|---|---|---|
| 2007-05-08 12:35:29.123 +12:15 | 735 | 2007-05-08 12:35:29.123 +12:15 |
Notice that the ending result is the same as the starting set. This is a success. Where as if you would have used SwitchOffset, the time would have changed, because it would assume that your original time was UTC, and you wanted to look at it in another timezone.
From this you should have learned a little more about DatePart, and ToDateTimeOffset.
Brian By Experience 