开发者

SQL Server 2008 storage of xs:date and xs:time shifted to GMT

开发者 https://www.devze.com 2022-12-16 05:00 出处:网络
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

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消