开发者

Problem deserializating JSON Date in C# - adding 2 hours

开发者 https://www.devze.com 2023-01-27 05:29 出处:网络
We are having such a nasty problem when deserializating a JSON date to a C# DateTime. The code is: JavaScriptSerializer serializer = new JavaScriptSerializer();

We are having such a nasty problem when deserializating a JSON date to a C# DateTime.

The code is:

JavaScriptSerializer serializer = new JavaScriptSerializer();
jsonTrechos = jsonTrechos.Replace("/Date(", "\\/Date(").Replace(")/", ")\\/");
Trecho[] model = serializer.Deserialize<Trecho[]>(jsonTrechos);

The jsonTrechos is a string of json2.js's JSON.stringify();.

Problem is: the deserialization works, bur all dates of the Trechos objects are added with 2 hours.

My timezone is Brazil (UTC -3) and we're under daylight savings (so we're currently on UTC -2), if it has anything to do. I guess that perhaps localization and timezones may be playing a part on this and if they really are, I have no idea on 开发者_JAVA百科how to fix it.


This is documented in the MSDN:

Date object, represented in JSON as "/Date(number of ticks)/". The number of ticks is a positive or negative long value that indicates the number of ticks (milliseconds) that have elapsed since midnight 01 January, 1970 UTC.

Try calling DateTime.ToLocalTime() and see if you get the correct date for you.


I would strongly recommend working with the Json.NET library. Quite frankly, the JSON serializers (and there are multiple ones) in the .NET framework are all quirky in some way, especially when it comes to serializing dates.

Json.NET is the only library that I've seen that handles them (and JSON in general) consistently and without problem for other consumers.


The dates specified for JSON are UTC, and as you've mentioned you're using daylight savings so +2 hours makes sense. Ideally you should be working with UTC date times anyway, as it removes the headaches of daylight savings (or in this case, it's added to it) and allows for global hosting.


"Javascript dates are calculated in milliseconds from 01 January, 1970 00:00:00 Universal Time (UTC) with a day containing 86,400,000 milliseconds" (Excerpt from W3schools). So you want to convert it to your local timezone.

TimeZoneInfo.ConvertTimeFromUtc(yourDateToConvert, TimeZoneInfo.Local)
0

精彩评论

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