Javascript regex for mysql time stamp format not working

Question

I need to recognize if a string has the proper mysql DB time stamp format in javascript. I wrote this regexp:

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

However when used with the string

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

It doesn't work. Can anyone tell me what I did wrong?

Thank you. Please post it as answer so I can mark it right. Worst part about it is that I looked it up and did not see the difference. — aarelovich
– aarelovich, Commented Apr 29, 2016 at 12:35

Clément Andraud · Accepted Answer · 2016-04-29 12:45:20Z

2

The regex for this date format is : (\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})

Here a 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");
    }

edited Apr 29, 2016 at 12:45

answered Apr 29, 2016 at 12:34

Clément Andraud

9,26927 gold badges89 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

kfairns Over a year ago

([\d]{4}-[\d]{2}-[\d]{2} (?:[\d]{2}:){2}[\d]{2}) will complete it faster, as it takes less steps (7 according to my regex tester). It all depends on whether the op is doing 1 or many. here

RomanPerekhrest · Accepted Answer · 2016-04-29 12:49:50Z

1

There's 2 errors in your approach:

a) incorrect character class [0..9](should be [0-9]);
b) tested string is not specified in regex.test function call

 var regex = /[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}/g;
 var s = "2014-09-08 08:02:17";
 if (regex.test(s)){
    console.log("OK");
 }

edited Apr 29, 2016 at 12:49

answered Apr 29, 2016 at 12:35

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

Comments

Avinash Raj · Accepted Answer · 2016-04-29 12:35:36Z

0

Add anchors and replace .. with -. Because - inside a character class (not at the first or last) should act like a range quantifier.

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

And anchors, yes it's must. Otherwise your regex should match this 54632014-09-08 08:02:173563 . Anchors will do an exact match, you may replace anchors with \b if you don't want to do an exact match.

answered Apr 29, 2016 at 12:35

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

Collectives™ on Stack Overflow

Javascript regex for mysql time stamp format not working

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related