yyyy-mm-dd hh:mm:ss 转换 mysql date_将数据库中的dateTime 时间格式转换成yyyy-MM-dd HH:mm:ss...

将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;

}