数据库中取出来的时间格式是: 2019-09-02T16:00:00.000+0000 这样的,
需要把他换成这样的: 2019-09-12 23:52:29
首先一个函数:
function timeStamp2String(time){
var datetime = new Date();
datetime.setTime(time);
var year = datetime.getFullYear();
var month = datetime.getMonth() + 1 < 10 ? "0" + (datetime.getMonth() + 1) : datetime.getMonth() + 1;
var date = datetime.getDate() < 10 ? "0" + datetime.getDate() : datetime.getDate();
var hour = datetime.getHours()< 10 ? "0" + datetime.getHours() : datetime.getHours();
var minute = datetime.getMinutes()< 10 ? "0" + datetime.getMinutes() : datetime.getMinutes();
var second = datetime.getSeconds()< 10 ? "0" + datetime.getSeconds() : datetime.getSeconds();
return year + "-" + month + "-" + date+" "+hour+":"+minute+":"+second;
}
然后 timeStamp2String(Date.parse(str)); str 就是数据库中取出来的值
$(function () {
$("#btn").click(
function () {
$.post("/ajax/a1",function (data,status) {
console.log(data);
var html = "";
for (var i = 0; i < data.length; i++) {
html += "<tr>"+
"<td>"+data[i].id+"</td>"+
"<td>"+data[i].username+"</td>"+
"<td>"+data[i].sex+"</td>"+
"<td>"+data[i].birthday+"</td>"+
"<td>"+data[i].email+"</td>"+
"<td>"+data[i].userLevel+"</td>"+
//
"<td>"+timeStamp2String(Date.parse(data[i].createTime))+"</td>"+
"<td>"+timeStamp2String(Date.parse(data[i].updateTime))+"</td>";
}
$("#tb").html(html);
})
})
})
</script>