Geo Thomas Geo Thomas - 4 months ago 62
jQuery Question

format json date to mm/dd/yy format before displaying in a jquery datatable

I am trying to display some data in a datatable and the table script I am using is

$('#userData').dataTable({

"ajax": {
"url": "${rc.getContextPath()}/module/roles/users-list",
"dataSrc": "",
},

"columns":[
{"data": "userId"},
{"data": "applicationId"},
{"data": "username"},
{"data": "firstName"},
{"data": "userCreated"},
{"data": "createdTime"},
{"data": "updatedTime"}
],

});


the data that is received by the table is json and would be something like

[
{
"userId":179,
"applicationId":"pgm-apn",
"username":"collaborator.user3",
"password":"password1",
"email":"user@xample.com",
"firstName":"Anthony",
"lastName":"Gonsalves",
"enabled":true,
"userCreated":"sitepmadm",
"userModified":"sitepmadm",
"createdTime":1422454697373,
"updatedTime":1422454697373
},
{
"userId":173,
"applicationId":"pgm-apn",
"username":"consumer.user",
"password":"password1",
"email":"test@egc.com",
"firstName":"sherlock ",
"lastName":"homes",
"enabled":true,
"userCreated":"sitepmadm",
"userModified":"sitepmadm",
"createdTime":1422010854246,
"updatedTime":1422010854246
}


I want to display the dates as proper datetime.Currently it is getting displayed as teh same sting in the json data.Is there any way to convert that in the datatable

Answer

You can use "render" property to format your column display http://datatables.net/reference/option/columns.render#function.

For example:

{
    "data": "createdTime",
    "render": function (data) {
        var date = new Date(data);
        var month = date.getMonth() + 1;
        return (month.length > 1 ? month : "0" + month) + "/" + date.getDate() + "/" + date.getFullYear();
    }
}
Comments