日期时间值未在jQuery数据表中正确显示 [英] Datetime value not showing properly in jQuery data table
本文介绍了日期时间值未在jQuery数据表中正确显示的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在数据表中获取时间戳。如何格式化我的日期时间在jQuery数据表功能?
I want to get the timestamp in data table . how to format my datetime in the jquery datatable function?
sql server datatime数据,如何编辑列,以便我无法在数据时间中获取正确的datetime。我已经尝试过使用类型:'date-dd-mmm-yyyy',但它不起作用
sql server datatime data, how to edit the columns so that i cant get the proper datetime in the data time. i have tried with type: 'date-dd-mmm-yyyy', but its not working
2018-11-23 07:49:35.073
data type - date time
javascript
javascript
$(document).ready(function () {
$('#myTable').DataTable({
"ajax": {
"url": "/Temperature/loaddata",
"type": "GET",
"datatype": "json"
},
"columns": [
{ "data": "id", "autoWidth": true },
{ "data": "updatedDate", "autoWidth": true, type: 'date-dd-mmm-yyyy', targets: 0 },
{ "data": "deviceid", "autoWidth": true },
{ "data": "devicename", "autoWidth": true },
{ "data": "temp", "autoWidth": true },
{ "data": "faht", "autoWidth": true }
]
});
});
c#代码
public ActionResult loaddata()
{
using (smartpondEntities dc = new smartpondEntities())
{
var data = dc.Temperatures.OrderBy(a => a.id).ToList();
return Json(new { data = data}, JsonRequestBehavior.AllowGet);
}
}
json样本数据
[{"id":1,"updatedDate":"2018-11-23T07:49:35.073","DeviceTime":null,"deviceid":1,"devicename":"aaaa","temp":28.50,"faht":87.90},{"id":2,"updatedDate":"2018-11-23T07:49:42.1","DeviceTime":null,"deviceid":1,"devicename":"aaaa","temp":28.50,"faht":87.90}]
输出
/Date(1542939575073)/
exp op
23 Nov 2018 13:10:10
推荐答案
我使用 moment.js 用于日期时间( docs )。因此在您的渲染中:
i use moment.js for datetimes (docs). so in your render:
{
title: "Date",// name
render: function (data, type, row) {//data
return moment(row.updatedDate).format('DD/MM/YYYY hh:mm:ss');
}
}
这篇关于日期时间值未在jQuery数据表中正确显示的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文