Json Date Conversion

[#1]

Hi All,

I am getting a response of date in Json format /Date(253402300799000) which I want to show in as a normal date on my UI (dd/mm/yyyy). I have written a function to convert it but for certain scenarios it is failing like for date 9999-12-31 & 1900-01-01.

When I convert the above one it is giving me the date 1-1-10000 & 1-1-2040.

here is the function which I have Written :

for (var i = 0; i < oData.date.length; i++)

{

var oDate = oData.date[i].DATE.match(/\d+/g);

var oDate1 = new Date(parseInt(oDate));

var sDate = oDate1.getMonth() + 1 + "-" + oDate1.getDate() + "-" + oDate1.getFullYear();

oData.date[i].DATE = sDate;

}

Note : I am using xsoData.

[Former Member]

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 .