JavaScriptSerializer is subtracting one day from date

Question

I am using JavaScriptSerializer for serializing DateTime, but when I deserialize it show one day less from the date it get serialize:

Here is test:

  DateTime startDate=new DateTime(2012,1,20);//set the 20th of January
  JavaScriptSerializer  serializer=new JavaScriptSerializer();
  string serializeDate= serializer.Serialize(startDate);
  DateTime afterDeserialize= serializer.Deserialize<DateTime>(serializeDate);//I get 19th of Jan
  Assert.Equals(startDate, afterDeserialize);

firstly I thougt it because of javascript datetime format but as I know for javascript Month is zero index 0=January, but I am getting one day less than the original date.

Solution 1: muck around with timezones, etc. Solution 2: just store the year, month and day as separate values, then recombine after deserialization. — JDB, Feb 21 '13 at 13:36

Brad Christie · Accepted Answer · 2013-11-13T20:59:20.423

20

It's not losing a day arbitrarily, it's converting to a UTC date (or I should say using the date in a UTC date format) so when it's unserialized it you're no longer within your personal time zone. It's basically performing:

DateTime whateverDate = /* incoming date */;
long ticks = whateverDate.ToUniversalTime() // make UTC
  .Subtract(new DateTime(1970, 1, 1))       // subtract UNIX Epoch
  .TotalMilliseconds();                     // get milliseconds since then
// push in to the "\/Date(ticks)\/" format
String value = String.Format(@"\/Date({0})\/", ticks);

However, try the following:

// or you rely on it serializing, then bring it back to your own local time
// (apply the time zone).
afterDeserialize = afterDeserialize.ToLocalTime();

You'll now have the UTC time back to your local time (with time zone applied).

To Pass your test:

DateTime startDate              = new DateTime(2012,1,20);
JavaScriptSerializer serializer = new JavaScriptSerializer();
String serializeDate            = serializer.Serialize(startDate);
DateTime afterDeserialize       = serializer.Deserialize<DateTime>(serializeDate)
                                  .ToLocalTime(); // Note: this is added

Assert.Equals(startDate, afterDeserialize); // pass!

edited Nov 13 '13 at 20:59

answered Feb 21 '13 at 13:30

Brad Christie

100,477
16
156
200

2

This is the [documented behavior](http://msdn.microsoft.com/en-us/library/bb299886.aspx#intro_to_json_topic2), albeit very unclear. – JDB Feb 21 '13 at 13:33
DateTime startDate = new DateTime(2012, 1, 20).ToUniversalTime(); it sets the startDate to 19 jan? and on deserialize getting the same... Why it is happening? – Zaheer Ahmed Feb 21 '13 at 13:33
1

http://blog.devarchive.net/2008/02/serializing-datetime-values-using.html Here is a blog explaining the problem quite in detail – Evelie Feb 21 '13 at 13:34
@ZaheerAhmed - it's changing the timezone. There's an implicit midnight attached to your date, so your are probably losing a few hours in the timezone shift, causing the date to change. – JDB Feb 21 '13 at 13:35
My timezone is PST, how can I input and get output in the same timezone. – Zaheer Ahmed Feb 21 '13 at 13:37
This - and many other reasons - are why you should use [Json.Net](http://james.newtonking.com/projects/json-net.aspx) instead of the `JavaScriptSerializer` – Matt Johnson-Pint Feb 26 '13 at 20:35
@ZaheerAhmed - Consider using a `DateTimeOffset` and serialize in ISO8601 format instead, using [Json.Net](http://james.newtonking.com/projects/json-net.aspx) instead of the `JavaScriptSerializer`. – Matt Johnson-Pint Feb 26 '13 at 20:41

score 4 · Answer 2 · answered Jan 07 '16 at 11:56

I had the same problem and solved it by using

Newtonsoft.Json.JsonConvert.SerializeObject()

instead of

new System.Web.Script.Serialization.JavaScriptSerializer().Serialize().

The latter call stores your DateTime converted to some random timezone (GMT+0 seems to be hardcoded).

Zaheer Ahmed · Answer 3 · 2014-02-02T10:30:04.303

2

On deserializing JavaScriptSerializer giving me output in UTC (Universal Time) which due to change in hours change the date. As Brad Christie suggested to change DateTime to UTC it can solve the problems.

But actually there is no need to change the:

DateTime startDate = new DateTime(2012, 1, 20).ToUniversalTime();

as it is already taking it as Universal Time. So I just convert the output of deserialize to LocalTime:

 DateTime afterDeserialize= serializer.Deserialize<DateTime>(serializeDate);
 afterDeserialize.ToLocalTime();

it solved the issue.

edited Feb 02 '14 at 10:30

answered Feb 21 '13 at 13:48

Zaheer Ahmed

28,160
11
74
110

Funny, was just in the middle of typing that up in an update to my answer. ;-) – Brad Christie Feb 21 '13 at 13:52
:), marked your answer correct, and just put this here, so it helps others – Zaheer Ahmed Feb 21 '13 at 13:55

JavaScriptSerializer is subtracting one day from date

3 Answers3

Linked

Related