mysql时间戳格式的Javascript正则表达式不起作用

Question

我需要在 JavaScript 中识别字符串是否具有正确的 mysql DB 时间戳格式。我写了这个正则表达式:

var regex = /([0..9]{4})-([0..9]{2})-([0..9]{2}) ([0..9]{2}):([0..9]{2}):([0..9]{2})/;

但是当与字符串一起使用时

var s = "2014-09-08 08:02:17";
if (regex.test){
   console.log("OK");
}

这不起作用。谁能告诉我我做错了什么？

Answer 1

此日期格式的正则表达式为:(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2 }):(\d{2})

这里有一个 JsFiddle :https://jsfiddle.net/2vh23Lmt/

    var string = "2014-09-08 08:02:17";
    var re = /(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/g;
    if (re.test(string)) {
        console.log("Valid");
    } else {
        console.log("Invalid");
    }