JSON Date Formatting

Question

I'm having an issue with the date format when getting JSON Date/Time.

I've managed to get the date format to: 2009-06-25T17:32:10.0000000

But I need to be: 25/06/2009 17:32:10

But since I'm getting this data from a loop I've trouble finding out how exactly to format the date so that the data is still extracted correctly in the loop. So far the closest I've come is using the Jquery FormatDateTime (which I've added a script Reference for at the start of the document):

//Get Pages Visited
        response.Result.PagesViewed.forEach(function (o, i, arr) {
            o.PageTime = $formatDateTime('dd/mm/yy hh:ii', o.PageTime);
            $('#PagesViewedRows').html("<tr class='info'><td>" + o.PageTime + "</td><td>" + o.PageStatus + "</td><td>" + o.PageName + "</td></tr>");
});

How can I format the o.PageTime to display correctly?

you want to store the formatted date for later use? or what? — Marc B
– Marc B, Commented Jun 15, 2015 at 14:24
Nah I want to display it inside <td>" + [formatted date here] + "</td> — Web Develop Wolf
– Web Develop Wolf, Commented Jun 15, 2015 at 14:26
"I've managed to get the date format to: 2009-06-25T17:32:10.0000000" — Web Develop Wolf
– Web Develop Wolf, Commented Jun 15, 2015 at 14:27

ben · Accepted Answer · 2015-06-15 14:33:07Z

1

You don't really need JQuery for that. Plain javascript works as well:

var date = new Date('2009-06-25T17:32:10.0000000');
console.log(date.getDate() + '/' + (date.getMonth() + 1) + '/' + date.getFullYear() + ' ' + date.getHours() + ':' + date.getMinutes() + ':' + date.getSeconds());

answered Jun 15, 2015 at 14:33

ben

3,5781 gold badge19 silver badges29 bronze badges

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

Comments

guest271314 · Accepted Answer · 2015-06-15 14:40:54Z

0

Try

var d = new Date().toJSON().split(/-|T|\..*/).filter(Boolean);
var res = d.slice(0, 3).reverse().join("/").concat(" " + d.slice(-1));
console.log(res);

answered Jun 15, 2015 at 14:40

guest271314

1

Collectives™ on Stack Overflow

JSON Date Formatting

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related