How do I convert a json date format to the following dd/mm/yyyy

Question

I've seen other examples but I am looking for this specific format if possible?.

possible duplicate of [How to format JSON Date?](http://stackoverflow.com/questions/206384/how-to-format-json-date) — David Hoerster, Mar 09 '11 at 16:37
these examples do not have dd/mm/yyyy format, well the one they do have doesnt work — Calibre2010, Mar 09 '11 at 16:45

score 7 · Answer 1 · edited Sep 14 '12 at 14:06

7

Here is a quick format from JSON date format to required date format using jQuery:

For a JSON date string like:

/Date(1339439400000)/

try:

var newFormattedDate = $.datepicker.formatDate('mm/dd/yy', new Date(Date(your_JSON_date_string)));

and it will result in date like this: 09/14/2012

edited Sep 14 '12 at 14:06

j0k

22,600
28
79
90

answered Sep 14 '12 at 13:55

nsingh

79
1
2

datepicker just to parse date ? – Royi Namir Dec 01 '12 at 07:26

Thulasiram · Answer 2 · 2012-08-18T16:07:27.107

6

    function formatJsonDate(jsonDate) {
        return (new Date(parseInt(jsonDate.substr(6)))).format("dd/mm/yyyy");
    };    

    var testJsonDate = formatJsonDate('/Date(1224043200000)/');

    alert(testJsonDate);

edited Aug 18 '12 at 16:07

answered Jul 13 '12 at 07:14

Thulasiram

8,432
8
46
54

score 2 · Answer 3 · answered Mar 09 '11 at 16:39

2

There is no "json date format". json only returns strings.

Date javascript object can parse a variety of formats. See the documentation.

You can do:

var myDate = new Date(myDateAsString);

answered Mar 09 '11 at 16:39

Vincent Mimoun-Prat

28,208
16
81
124

score 1 · Answer 4 · edited May 23 '17 at 12:01

There are a few suggestions in the answers to this post -- How do I format a Microsoft JSON date?

If those examples aren't working, you can just format it manually. Here's a quick fiddle that demonstrates it -- http://jsfiddle.net/dhoerster/KqyDv/

$(document).ready(function() {
    //set up my JSON-formatted string...
    var myDate = new Date(2011,2,9);
    var myObj = { "theDate" : myDate };
    var myDateJson = JSON.stringify(myObj);

    //parse the JSON-formatted string to an object
    var myNewObj = JSON.parse(myDateJson);

    //get the date, create a new Date object, and manually format the date string
    var myNewDate = new Date(myNewObj.theDate);
    alert(myNewDate.getDate() + "/" + (myNewDate.getMonth()+1) + "/" + myNewDate.getFullYear());
});

How do I convert a json date format to the following dd/mm/yyyy

4 Answers4