开发者

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.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜