Regex for custom Date format

Question

I have the regular expression as:

var validDate = /^\d{4}-((0\d)|(1[012]))-(([012]\d)|3[01]) (([0-1]?[0-9])|([2][0-3])):([0-5]?[0-9]):([0-5]?[0-9]).([0-9]?[0-9]?[0-9])$/i.test(value);

The value I am providing is Nov 21, 2014 12:00:00 AM.

Can anybody please help me in providing with the actual date expression (value) that will actually test the regex?

try this one 2014-02-31 23:00:59999 that will pass the above test, exposing two bugs, one easily fixed, the other not so easy. — Jasen
– Jasen, Commented Dec 24, 2014 at 7:15
the above test requires a digit one place after the seconds part of the time. the expression looks like a failed attempt to describe some variant of ISO-9601. 2014-02-31 23:00:666 also "works" — Jasen
– Jasen, Commented Dec 24, 2014 at 7:19

anubhava · Accepted Answer · 2014-12-24 07:08:30Z

1

Why not use built-in Date.parse:

var epochVal = Date.parse("Nov 21, 2014 12:00:00 AM")
//=> 1416546000000

OR:

var dt = new Date( Date.parse("Nov 21, 2014 12:00:00 AM") )
//=> Fri Nov 21 2014 00:00:00 GMT-0500 (EST)

answered Dec 24, 2014 at 7:08

anubhava

790k67 gold badges603 silver badges671 bronze badges

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

Comments

Jerry · Accepted Answer · 2014-12-24 09:01:19Z

0

Can anybody please help me in providing with the actual date expression (value) that will actually test the regex.

I won't provide the value, but rather the format of what the regex matches:

####-mm-dd HH:MM:ss.###

Where # denotes a number, mm denotes a month, dd denotes a date, HH denotes an hour in 24-hour format, MM denotes minutes and ss denotes seconds.

edited Dec 24, 2014 at 9:01

answered Dec 24, 2014 at 7:08

Jerry

71.8k14 gold badges106 silver badges148 bronze badges

3 Comments

Jasen Over a year ago

and (bug) the . could be any character at all!

Jerry Over a year ago

@Jasen Oh yea, nicely spotted.

Jerry Over a year ago

Also, the regex can accept any date, even if it is not valid like the 30th of February.

Jasen · Accepted Answer · 2014-12-24 07:23:24Z

0

try this one 2014-02-13 23:00:59.0

answered Dec 24, 2014 at 7:23

Jasen

12.5k2 gold badges37 silver badges50 bronze badges

2 Comments

brandonscript Over a year ago

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post.

Jasen Over a year ago

@remus It answers this bit. Can anybody please help me in providing with the actual date expression (value) that will actually test the regex., well "yes" would be technically more accurate but it too short to satisfy stack exchange.

Collectives™ on Stack Overflow

Regex for custom Date format

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related