| Title |
Test
Find
yyyy/mm/dd hhMMss Date
|
| Expression |
^(?ni:(?=\d)((?'year'((1[6-9])|([2-9]\d))\d\d)(?'sep'[/.-])(?'month'0?[1-9]|1[012])\2(?'day'((?<!(\2((0?[2469])|11)\2))31)|(?<!\2(0?2)\2)(29|30)|((?<=((1[6-9]|[2-9]\d)(0[48]|[2468][048]|[13579][26])|(16|[2468][048]|[3579][26])00)\2\3\2)29)|((0?[1-9])|(1\d)|(2[0-8])))(?:(?=\x20\d)\x20|$))?((?<time>((0?[1-9]|1[012])(:[0-5]\d){0,2}(\x20[AP]M))|([01]\d|2[0-3])(:[0-5]\d){1,2}))?)$ |
| Description |
YYYY/MM/DD hh:mm:ss format DateTime Regex.
This regex will validate a date, time or a datetime.
It will also capture the date fields and the time.
Dates are in the YYYY/MM/DD format and validated for months, number of days in a month and leap years (29/2)
Date field can be separated by matched periods(.), dashes(-) or forward slashes(/)
Time is either 12 hour AM/PM format (hh:mm:ss AM), where minutes and seconds are optional.
AM or PM required. or 24 hour military format (hh:mm:ss), from 00:00:00 to 23:59:59,
where hours and minutes fields are required, including leading 0 for hours less than 10.
Please refer to http://blogs.regexadvice.com/mash/archive/2004/04/23/1021.aspx for additional info
Datetime is the above date and time formats separated by a space,
with the date first (YYYY/MM/DD hh:mm:ss)
!IMPORTANT NOTE: your regex engine must support lookbehinds and named groups to use this expression |
| Matches |
12:30 PM | 2004-02-29 | 2004/3/31 02:31:35 AM |
| Non-Matches |
2:00 | 2200.2.29 | 0000/00/00 00:00:00 AM |
| Author |
Rating:
Michael Ash
|
| Source |
|
| Your Rating |
|
Title: Excellent
Name: Developer
Date: 9/12/2012 1:33:06 PM
Comment:
This is fantastic. I was wondering whether it would be possible to check just for datetime (YYYY/MM/DD hh:mm:ss) and without date, and time. Do you mind posting separate expressions for these?
Thanks!
Title: Excellent
Name: Developer
Date: 9/12/2012 11:56:31 AM
Comment:
This is fantastic. I was wondering whether it would be possible to check just for datetime (YYYY/MM/DD hh:mm:ss) and without date, and time. Do you mind posting separate expressions for these?
Thanks!
Title: Excellent
Name: Developer
Date: 9/12/2012 11:56:23 AM
Comment:
This is fantastic. I was wondering whether it would be possible to check just for datetime (YYYY/MM/DD hh:mm:ss) and without date, and time. Do you mind posting separate expressions for these?
Thanks!
Title: A
Name: B
Date: 2/3/2006 3:13:16 PM
Comment:
12:12 AM
Title: Thanks
Name: b3b4
Date: 6/30/2004 7:54:21 AM
Comment:
it's just the answer to my question,thanks!
