Parsing and formatting JSON date variable

Question

I am parsing a JSON object with JavaScript and displaying it in a styled HTML table.

The date variable comes as a long string. (e.g. 2011-11-23 10:21:49.695805)

How can I format the date so as to be displayed: year-month-day, hour-minute instead of 2011-11-23 10:21?

The AJAX call:

$$.ajax({
    url: '/ajax/myfolder',
    dataType:"json",
    success: function(json) {
        $$('#JsonGrid').append(CreateTableView(json, "jsonFeed", true)).fadeIn();  
        parseDate();
    }     
});

function parseDate() {

}

The json object:

[{"status": "success", "date": "2011-11-23 10:21:49.695805", "user": "xy", "jobname": "jobnamexyz"}]

You need to use a date parsing/formatting library, like datejs.com — Viruzzo
– Viruzzo, Commented Nov 23, 2011 at 11:53

nnnnnn · Accepted Answer · 2011-11-23 13:20:38Z

2

You can use date functions, DateJS, etc., but if the format is fixed as in your example you can just take the first sixteen characters:

var date = json["date"].substr(0,16);

EDIT: sorry, just noticed you wanted a comma in there. So:

var date = json["date"].substr(0,10) + ", " + json["date"].substr(11,5);

EDIT 2: OK, try moving the call to parseDate() to before you call CreateTableView(), so you can "fix" the data before it is used. The following assumes the json is an array of objects:

success: function(json) {
    parseDate(json);
    $$('#JsonGrid').append(CreateTableView(json, "jsonFeed", true)).fadeIn();


function parseDate(data) {
    for (var i=0; i<data.length; i++)
        if (data[i]["date"])
            data[i]["date"] = data[i]["date"].substr(0,10)
                            + ", " + data[i]["date"].substr(11,5);
}

edited Nov 23, 2011 at 13:20

answered Nov 23, 2011 at 11:57

nnnnnn

150k30 gold badges210 silver badges247 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

xxx12123 Over a year ago

here I get: json.date is undefined

nnnnnn Over a year ago

Surely you can take the substr() idea from my answer and slot it into your own code? I just noticed your sample JSON is an array with one item in it, so you could say json[0]["date"].substr(..., but presumably the real data may have more rows. Your placeholder parseDate() function as shown in the question is sitting on its own after you've appended whatever the return from CreateTableView() is to your document. I have no idea what that function does, but wouldn't you want to parse the dates inside that function? Or update the JSON before passing it to that function?

xxx12123 Over a year ago

CreateTableView function creates a standard table with column/rows, Parameter Information, objArray like JSON results. here is the code specification: zachhunter.com/2010/04/json-objects-to-html-table.. i guess there it would be better to do the time formatting before appending what is returned. I am just now sure how

xxx12123 Over a year ago

I get data[i].date is undefined data[i]["date"] = data[i]["date"].substr(0,10)

nnnnnn Over a year ago

I've updated my answer one more time to allow for items in that json array that don't have a date, but as far as I can see my updated code matches the sample data from your question. Your sample has an array with only one item in it (i.e., only one row in your table) so it's hard for me to see what the problem is - you'll have to figure out the rest.

|

Oleg · Accepted Answer · 2011-11-23 13:07:47Z

0

You can use String.match method to parse the parts of string like "2011-11-23 10:21:49.695805". For example the code

var regexp = "([0-9]{4})(-([0-9]{2})(-([0-9]{2})" +
             "([T| ]([0-9]{2}):([0-9]{2})(:([0-9]{2})(\.([0-9]+))?)?" +
             "(Z|(([-+])([0-9]{2}):([0-9]{2})))?)?)?)?";
var dateString = "2011-11-23 10:21:49.695805";
var d = dateString.match(new RegExp(regexp));

will initialize d as array where d[1], d[3], d[5], d[7], d[8] and d[10] are year (2011), month (11), day (23), hour (10), minutes (21), seconds (49). The d[12] will be 695805 and only the first tree digits of it are milliseconds. So you can either create a Date like

var date = new Date(d[1],d[3],d[5],d[7],d[8],d[10],d[12].substr(0,3));

or display the parsed date as another string in any other format which you prefer.

answered Nov 23, 2011 at 13:07

Oleg

222k36 gold badges414 silver badges826 bronze badges

2 Comments

nnnnnn Over a year ago

Doesn't var d = dateString.split(/[ :.-]/); do the same thing as your regex?

Oleg Over a year ago

@nnnnnn: The regex, which I use, verify additionally the input. Look at the constructs [0-9] for example.

erimerturk · Accepted Answer · 2011-11-23 13:46:32Z

0

$$.ajax({
    url: '/ajax/myfolder',
    dataType:"json",
    success: function(json) {
        $$('#JsonGrid').append(CreateTableView(json, "jsonFeed", true)).fadeIn();  
        parseDate(json);
    }     
});


  function parseDate(json) {

        var arr = json["date"].split(/:/);
        var date = arr[0] + ":"+arr[1];
        alert(date);

        return date;

    }

edited Nov 23, 2011 at 13:46

answered Nov 23, 2011 at 12:01

erimerturk

4,28827 silver badges25 bronze badges

2 Comments

xxx12123 Over a year ago

I get: date is undefined var arr = date.split(/:/, json.date);

erimerturk Over a year ago

sorry, it was my fault i updated it, i pasted the old script, but now it is ok. working.

Bas Slagter · Accepted Answer · 2011-11-23 11:54:23Z

-1

Maybe this jQuery extension can help you out: http://momentjs.com/

Like:

var now = moment();
var formatted = now.format('dddd, MMMM Do YYYY');

answered Nov 23, 2011 at 11:54

Bas Slagter

9,9479 gold badges50 silver badges81 bronze badges

Collectives™ on Stack Overflow

Parsing and formatting JSON date variable

4 Answers 4

6 Comments

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

6 Comments

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related