oracle里的日期时间格式,oracle中以下的日期格式肿么转成yyyy-mm-dd hh24:mi:ss

js中，利用Date.parseDate(dateValue) 方法来转换日期：

function parseDate(str) {

if (typeof str == 'string') {

var results = str.match(/^ *(\d{4})-(\d{1,2})-(\d{1,2}) *$/);

if (results && results.length > 3) return new Date(parseInt(results[1]), parseInt(results[2]) - 1, parseInt(results[3]));

results = str.match(/^ *(\d{4})-(\d{1,2})-(\d{1,2}) +(\d{1,2}):(\d{1,2}):(\d{1,2}) *$/);

if (results && results.length > 6) return new Date(parseInt(results[1]), parseInt(results[2]) - 1, parseInt(results[3]), parseInt(results[4]), parseInt(results[5]), parseInt(results[6]));

results = str.match(/^ *(\d{4})-(\d{1,2})-(\d{1,2}) +(\d{1,2}):(\d{1,2}):(\d{1,2})\.(\d{1,9}) *$/);

if (results && results.length > 7) return new Date(parseInt(results[1]), parseInt(results[2]) - 1, parseInt(results[3]), parseInt(results[4]), parseInt(results[5]), parseInt(results[6]), parseInt(results[7]));

}

return null;

}

var d = Date.parseDate("2015-08-02 12:13:15");

document.write(d + "\n");

输出一个JavaScript的Date类型。

取消

评论