Tuesday, April 27, 2021

Covert long date from json to DD-MM-YYYY in Datatable

Recevied JSON

{ "userId":173, "applicationId":"pgm-apn", "username":"consumer.user", "password":"password1", "email":"test@egc.com", "firstName":"sherlock ", "lastName":"homes", "enabled":true, "userCreated":"gtuser", "userModified":"gtuser", "createdTime":1422010854246, "updatedTime":1422010854246 }


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(); 
 } 
}

No comments:

Post a Comment