I am trying to display some data in a datatable and the table script I am using is
$('#userData').dataTable({
"ajax": {
"url": "my-url",
"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":"[email protected]",
"firstName":"Anthony",
"lastName":"Gonsalves",
"enabled":true,
"userCreated":"gtuser",
"userModified":"gtuser",
"createdTime":1422454697373,
"updatedTime":1422454697373
},
{
"userId":173,
"applicationId":"pgm-apn",
"username":"consumer.user",
"password":"password1",
"email":"[email protected]",
"firstName":"sherlock ",
"lastName":"homes",
"enabled":true,
"userCreated":"gtuser",
"userModified":"gtuser",
"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.toString().length > 1 ? month : "0" + month) + "/" + date.getDate() + "/" + date.getFullYear();
}
}