Convert JSON Date to JavaScript/jQuery date

var date = new Date(parseInt(jsonDate.substr(6)));

The JSON specification does not specify a format for exchanging dates which is why there are so many different ways to do it. Microsoft .NET Web APIs returns JSON dates in standardized format by default, but the older versions of .Net framework may serialize the C# datetime object into a strange string format like /Date(1530144000000+0530)/ or /Date(1530144000000)/ . The number within the JSON Date string actually denotes the number on milliseconds that have passed since 01-01-1970 .
json date to javascript

JSON does not know anything about dates. What .NET does is a non-standard hack/extension. The problem with dates in JSON and really JavaScript in general – is that there's no equivalent literal representation for dates. In JavaScript following Date constructor straight away converts the milliseconds since 1970 to Date as follows:

var jsonDate = new Date(1297246301973);

Then let's convert it to js format:

var date = new Date(parseInt(jsonDate.substr(6)));

The substr() function takes out the /Date( part, and the parseInt() function gets the integer and ignores the )/ at the end. The resulting number is passed into the Date constructor .

Browser View

Source Code

<html> <title></title> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function () { var inDate = "/Date(1297246301973)/"; //Wed Feb 09 2011 15:41:41 GMT+0530 (India Standard Time) var JavaScriptDate = new Date(parseInt(inDate.substr(6))); //to js format var dateObject = new Date(JavaScriptDate); //Date object var html = 'Input Date :' + inDate + '<br/>' + 'Full Date: ' + JavaScriptDate + '<br/>' + 'Date : ' + dateObject.getDate() + '<br/>' + 'Full Year: ' + dateObject.getFullYear() + '<br/>' + 'Hours): ' + dateObject.getHours() + '<br/>' + 'Minutes: ' + dateObject.getMinutes() + '<br/>' + 'Seconds : ' + dateObject.getSeconds() + '<br/>' + 'Time :' + dateObject.getTime() + '<br/>' + 'UTC Date : ' + dateObject.getUTCDate() + '<br/>' + 'UTC FullYear : ' + dateObject.getUTCFullYear() + '<br/>' + 'UTC Seconds : ' + dateObject.getUTCSeconds(); $('#myDiv').html(html); }); </script> </head> <body> <form id="myForm" runat="server"> <div id="myDiv"> </div> </form> </body> </html>

ISO-8601 formatted JSON dates

For ISO-8601 formatted JSON dates, just pass the string into the Date constructor:

var date = new Date(jsonDate);

Next : jQuery Interview Questions (Part-2)

Related Topics