Regular Expression for Date and Time Functions

Regular Expression for Date and Time Functions

Date Regular Expression

Format: MM/DD/YYYY

MM: (0[1-9]|1[0-2])

DD: (0[1-9]|1[0-9]|2[0-9]|3[0-1])

YYYY: ([0-9][0-9][0-9][1-9]|[1-9]000|[1-9][1-9]00|[1-9][1-9][1-9]0)

* Assuming that Max year is 9999

Time Regular Expression

24 hours format
Max Time: 23:59:59
Min  Time: 00:00:00

Hours: ([0-1][0-9]|2[0-3])

Mins: ([0-5][0-9])

Secs: ([0-5][0-9])

12 hours format
Max Time: 11:59:59
Min  Time: 00:00:00

Hours: (0[1-9]|1[0-2])

Mins: ([0-5][0-9])

Secs: ([0-5][0-9])

Special Character Explanation
| -- OR
Ex: a|b means a or b

( ) -- Used to group multiple regular expressions
[-] -- To specify a range

Ex:
a[x-z]=ax, ay , az
[a-c][x-z]=ax,ay,az,bx,by,bz,cx,cy,cz