SQL Server 2008 storage of xs:date and xs:time shifted to GMT
Is there any way to prevent SQL Server 2008 f开发者_如何转开发rom interpolating dates and times passed as xs:date and xs:time to UTC? Currently we're running the server at EST and any times passed in are kicked back -05:00. We'd like to prevent this as it's a very serious issue.
Regards.
The solutions were to either use full ISO 8601 data, or what I did instead: interpolate the data server-side as we operate from a fixed timezone. Since much of the XML source data could be brewed the 8601 option was too complex for our needs.
精彩评论