regex101: Europead date or MSSQL Timestamp

Explanation

Pro

Group 1(^(0?[1-9]|[12][0-9]|3[01])\.(0?[1-9]|1[012])\.(19|20)\d\d( ([01]?[0-9]|2[0-3]):[0-5][0-9])?$|^\{ts \'((19|20)\d\d)\-(0?[1-9]|1[012])\-(0?[1-9]|[12][0-9]|3[01]) ([01]?[0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9]\'\}$|^$)

1st Alternative^(0?[1-9]|[12][0-9]|3[01])\.(0?[1-9]|1[012])\.(19|20)\d\d( ([01]?[0-9]|2[0-3]):[0-5][0-9])?$

^start of string

Group 2(0?[1-9]|[12][0-9]|3[01])

1st Alternative0?[1-9]

0?optionally matches the literal 0 (48₁₀ / 60₈ / 30₁₆)

Character Class[1-9]

1-9one character from 1 (49₁₀) to 9 (57₁₀)

2nd Alternative[12][0-9]

Character Class[12]

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

2the literal 2 (50₁₀ / 62₈ / 32₁₆)

Character Class[0-9]

0-9one character from 0 (48₁₀) to 9 (57₁₀)

3rd Alternative3[01]

3the literal 3 (51₁₀ / 63₈ / 33₁₆)

Character Class[01]

0the literal 0 (48₁₀ / 60₈ / 30₁₆)

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Group 3(0?[1-9]|1[012])

1st Alternative0?[1-9]

0?optionally matches the literal 0 (48₁₀ / 60₈ / 30₁₆)

Character Class[1-9]

1-9one character from 1 (49₁₀) to 9 (57₁₀)

2nd Alternative1[012]

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

Character Class[012]

0the literal 0 (48₁₀ / 60₈ / 30₁₆)

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

2the literal 2 (50₁₀ / 62₈ / 32₁₆)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Group 4(19|20)

1st Alternative19

19the literal text 19

2nd Alternative20

20the literal text 20

\da digit

Group 5( ([01]?[0-9]|2[0-3]):[0-5][0-9])?

?repeats the group contents below at most once:

the literal (32₁₀ / 40₈ / 20₁₆)

Group 6([01]?[0-9]|2[0-3])

1st Alternative[01]?[0-9]

Character Class[01]?

?matches at most one character from the set below:

0the literal 0 (48₁₀ / 60₈ / 30₁₆)

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

Character Class[0-9]

0-9one character from 0 (48₁₀) to 9 (57₁₀)

2nd Alternative2[0-3]

2the literal 2 (50₁₀ / 62₈ / 32₁₆)

Character Class[0-3]

0-3one character from 0 (48₁₀) to 3 (51₁₀)

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Character Class[0-5]

Character Class[0-9]

$end of string, or before its final line terminator

2nd Alternative^\{ts \'((19|20)\d\d)\-(0?[1-9]|1[012])\-(0?[1-9]|[12][0-9]|3[01]) ([01]?[0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9]\'\}$

3rd Alternative^$

Quick Reference

25 tokens

Regular Expression

(^(0?[1-9]|[12][0-9]|3[01])\.(0?[1-9]|1[012])\.(19|20)\d\d( ([01]?[0-9]|2[0-3]):[0-5][0-9])?$|^\{ts \'((19|20)\d\d)\-(0?[1-9]|1[012])\-(0?[1-9]|[12][0-9]|3[01]) ([01]?[0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9]\'\}$|^$)

New

30.12.2013