将MySQL数据库中dateTime 数据格式转换成yyyy-MM-dd HH:mm:ss 格式。
基于转换date
这样的话只要在元素中添加 createTime class 属性即可实现格式转换。
$(function() {
$(".createTime").each(function() {
//debugger;
var createTime = $(this).text();
createTime = Todate(createTime);
//console.log(creatTime);
$(this).text(createTime);
});
});
// 将dateTime 格式转换成String yyyy-MM-dd HH:mm:ss
function Todate(num) {
num = num + "";
var date = "";
var month = new Array();
month["Jan"] = 1;
month["Feb"] = 2;
month["Mar"] = 3;
month["Apr"] = 4;
month["May"] = 5;
month["Jun"] = 6;
month["Jul"] = 7;
month["Aug"] = 8;
month["Sep"] = 9;
month["Oct"] = 10;
month["Nov"] = 11;
month["Dec"] = 12;
var week = new Array();
week["Mon"] = "一";
week["Tue"] = "二";
week["Wed"] = "三";
week["Thu"] = "四";
week["Fri"] = "五";
week["Sat"] = "六";
week["Sun"] = "日";
str = num.split(" ");
date = str[5] + "-";
date = date + month[str[1]] + "-" + str[2] + " " + str[3];
return date;
}