JSON Date Format mm / dd / yyyy

Question

Here is what I get as data:

jsonp1290537545248 ([{"Asset": true, "EndDate": "\ / Date (-62135578800000-0500) \ /", "StartDate": "\ / Date (1280635200000-0400) \ /"}]);

  $.getJSON(url, {},
      function (data) {
          alert(data[0].EndDate);
          alert(Date(data[0].StartDate));
          //alert(data[0].StartDate.getDate());// + "/" + (data[0].StartDate.getMonth() + 1) + "/" + data[0].StartDate.getFullYear()); // alerts: "15/10/2008" 
          //var date = eval(jsonDate.replace(/\/Date\((\d+)\)\//gi, "new Date($1)"));
          alert('dd    ' + new Date(parseInt(data.substr(6)))); 

      });

How do I get into the MM / DD / YYYY format?

Answer 1

I would use a similar regular expression for what Zain wrote, but would not use eval()like this ( demo ):

var start = parseInt(data.StartDate.replace(/\/Date\((.*?)[+-]\d+\)\//i,"$1"), 10),
    date = new Date( start ),
    fStart = date.getMonth()+1 + '/' + date.getDate() + '/' + date.getFullYear();

? , , "Sun Dec 31 0000 22:59:59 GMT-0600 (Central Standard Time)"... .

Answer 2

. . http://jsfiddle.net/zainshaikh/pysAR/.

var date = eval(data[0].StartDate.replace(/\/Date\((.*?)\)\//gi, "new Date($1)"));

JavaScript script (1,2 gzipped), .

Microsoft JSON?

Answer 3

. , - Date.getTime() Java JavaScript (.. 1 1970 , 00:00:00 UTC).

(, -0500 ) Date, UTC . , JavaScript Date.setTimezoneOffset(), ( ).

, . , , Date, (demo: http://jsfiddle.net/Wa8LY/1/).

var dateParts = data[0].StartDate.match(/\((.*)([+-])(..)(..)\)/);
var dateObj = new Date(
    /* timestamp in milliseconds */ Number(dateParts[1]) +
    /* sign of timezone offset */ Number(dateParts[2] + '1') *
    /* hours and minutes offset */ (36e5 * dateParts[3] + 6e4 * dateParts[4])
);

var dateMMDDYYYY = [dateObj.getUTCMonth() + 1,
                    dateObj.getUTCDate(),
                    dateObj.getUTCFullYear()].join('/');

(, 01/01/0001), , :

function leftPadWithZeroes(str, len) {
    return (new Array(len + 1).join('0') + str).slice(-len);
}

(demo: http://jsfiddle.net/5tkpV/1/):

var dateMMDDYYYY = [leftPadWithZeroes(dateObj.getUTCMonth() + 1, 2),
                    leftPadWithZeroes(dateObj.getUTCDate(), 2),
                    leftPadWithZeroes(dateObj.getUTCFullYear(), 4)].join('/');

Answer 4

JSON Javascript

jQuery, , , Javascript.

- $.parseJSON() , , . - , .

. , .

Answer 5

, datestring "/Date (1334514600000) \"

'function ConvertJsonDateString(jsonDate) {  
   var shortDate = null;    
   if (jsonDate) {  
       var regex = /-?\d+/;  
       var matches = regex.exec(jsonDate);  
       var dt = new Date(parseInt(matches[0]));  
       var month = dt.getMonth() + 1;  
       var monthString = month > 9 ? month : '0' + month;  
       var day = dt.getDate();  
       var dayString = day > 9 ? day : '0' + day;  
       var year = dt.getFullYear();  
       shortDate = monthString + '/' + dayString + '/' + year;  
}  
return shortDate;  
};'