Displaying page
of
pages;
Items to
|
Title |
Test
Details
Pattern Title
|
|
Expression |
^((((([13578])|(1[0-2]))[\-\/\s]?(([1-9])|([1-2][0-9])|(3[01])))|((([469])|(11))[\-\/\s]?(([1-9])|([1-2][0-9])|(30)))|(2[\-\/\s]?(([1-9])|([1-2][0-9]))))[\-\/\s]?\d{4})(\s((([1-9])|(1[02]))\:([0-5][0-9])((\s)|(\:([0-5][0-9])\s))([AM|PM|am|pm]{2,2})))?$
|
|
Description |
This expression can be used validate a datetime column from SQL Server. Big parts of it where taken from other samples on RegexLib. Please feel free to take it apart and improve it.
|
|
Matches |
3/3/2003 | 3/3/2002 3:33 pm | 3/3/2003 3:33:33 am
|
|
Non-Matches |
13/1/2002 | 3/3/2002 3:33 | 31/3/2002
|
|
Author |
Rating:
Not yet rated.
Scott Watermasysk Watermasysk
|
Displaying page
of
pages;
Items to
