I have an xml with a date/time with offset:
I'm reading this through openxml and my server is in CST:
declare @DT datetime2(0)
select @DT = start
from openxml ( @idoc, '/root', 1 )
with ( start datetime2 'start' )
When I query for @DT I get: 2014-07-01 19:00:00, which is the date/time in UTC, because of the 6-hour offset.
My understanding is that the XML is in UTC and the offset is provided to identify the time zone where the data was originated. I need to read the data such that is returns 2014-07-01 13:00:00.
Can someone please explain what is that I'm doing wrong?