如何格式化Datatable中显示的日期 [英] How to format date displayed in Datatable
本文介绍了如何格式化Datatable中显示的日期的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个使用数据表显示数组中对象的函数。将日期和时间格式从ISODate更改为人类可读格式我有点问题。
I have a function that displays objects in my array using datatables. I'm a bit a problem with changing the date and time format from ISODate to human readable format.
myData
var datas = {"rows" : [{_id: "2017-01-03T00:00:00.000Z", Humidity: 24, Temperature: 18},
{_id: "2017-01-04T00:00:00.000Z", Humidity: 23.071428571428573, Temperature: 18.928571428571427} ]}
JS脚本
var table = $('#myTable').DataTable( {
data: datas.rows,
"columns": [
{ data: "_id" },
{ data: "Temperature" },
{ data: "Humidity" }
]
});
感谢您的预期帮助。
推荐答案
如上面@Paul Abbott所述,momentjs和渲染函数应该看对你:
As noted by @Paul Abbott above, momentjs and a render function should see you right:
var datas = {
"rows": [
{
_id: "2017-01-03T00:00:00.000Z",
Humidity: 24,
Temperature: 18
},
{
_id: "2017-01-04T00:00:00.000Z",
Humidity: 23.071428571428573,
Temperature: 18.928571428571427
}
]
}
var table = $('#myTable').DataTable( {
data: datas.rows,
"columns": [
{
data: "_id",
render: function(data, type, row){
if(type === "sort" || type === "type"){
return data;
}
return moment(data).format("MM-DD-YYYY HH:mm");
}
},
{
data: "Temperature"
},
{
data: "Humidity"
}
]
});
这篇关于如何格式化Datatable中显示的日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文