regex101: Datetime different formats

Pro

^start of line

Group 1(\d{1,4})

\d{1,4}a digit, repeated between 1 and 4 times

Character Class[\/|-|.\S]

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

|-|one character from | (124₁₀) to | (124₁₀)

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

\Sany non-whitespace character

Group 2(\d{1,2})

\d{1,2}a digit, repeated between 1 and 2 times

Character Class[\/|-|.|\S]

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

|-|one character from | (124₁₀) to | (124₁₀)

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

|the literal | (124₁₀ / 174₈ / 7C₁₆)

\Sany non-whitespace character

Group 3(\d{1,4})

\d{1,4}a digit, repeated between 1 and 4 times

Character Class[\T|\s]

\Tthe literal T (84₁₀ / 124₈ / 54₁₆) (case sensitive)

|the literal | (124₁₀ / 174₈ / 7C₁₆)

\sany whitespace character

Group 4(\d{1,2})

\d{1,2}a digit, repeated between 1 and 2 times

Character Class[\:]

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

Group 5(\d{1,2})

\d{1,2}a digit, repeated between 1 and 2 times

Character Class[\S|:]

\Sany non-whitespace character

|the literal | (124₁₀ / 174₈ / 7C₁₆)

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

Group 6(\d{2})?

?repeats the group contents below at most once:

\d{2}a digit, repeated exactly 2 times

Character Class[\:|\s|.|Z]?

?matches at most one character from the set below:

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

|the literal | (124₁₀ / 174₈ / 7C₁₆)

\sany whitespace character

|the literal | (124₁₀ / 174₈ / 7C₁₆)

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

Zthe literal Z (90₁₀ / 132₈ / 5A₁₆) (case sensitive)

Group 7(\d{7})?

?repeats the group contents below at most once:

\d{7}a digit, repeated exactly 7 times

Non-Capturing Group(?:AM)?

?repeats the group contents below at most once:

AMthe literal text AM (case sensitive)

Non-Capturing Group(?:PM)?

?repeats the group contents below at most once:

PMthe literal text PM (case sensitive)

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

25 tokens

Regular Expression

^(\d{1,4})[\/|-|.\S](\d{1,2})[\/|-|.|\S](\d{1,4})[\T|\s](\d{1,2})[\:](\d{1,2})[\S|:](\d{2})?[\:|\s|.|Z]?(\d{7})?(?:AM)?(?:PM)?$

New

Validated

01.10.2008 17:04
10/1/2008 5:04 AM
01/10/2008 17:04
01.10.2008 17:04:32
10/1/2008 5:04:32 PM

2008-10-01T17:04:32.0000000
2008-10-01T17:04:32
2008-10-01 17:04:32Z




Not Works!
01.10.2008 17:04 '
10/1/2008 5:04 PM '
01/10/2008 17:04 ' 
01.10.2008 17:04:32 '
10/1/2008 5:04:32 PM '

2008-10-01T17:04:32.0000000 '
2008-10-01T17:04:32 ' 
2008-10-01 17:04:32Z '

Validate!
01.10.2008 17:04

10/1/2008 5:04 PM
01/10/2008 17:04
01.10.2008 17:04:32
10/1/2008 5:04:32 PM

2008-10-01T17:04:32.0000000
2008-10-01T17:04:32
2008-10-01 17:04:32Z

Extraction

Validated

01.10.2008 17:04
10/1/2008 5:04 AM
01/10/2008 17:04
01.10.2008 17:04:32
10/1/2008 5:04:32 PM

2008-10-01T17:04:32.0000000
2008-10-01T17:04:32
2008-10-01 17:04:32Z




Not Works!
01.10.2008 17:04 '
10/1/2008 5:04 PM '
01/10/2008 17:04 ' 
01.10.2008 17:04:32 '
10/1/2008 5:04:32 PM '

2008-10-01T17:04:32.0000000 '
2008-10-01T17:04:32 ' 
2008-10-01 17:04:32Z '

Validate!
01.10.2008 17:04

10/1/2008 5:04 PM
01/10/2008 17:04
01.10.2008 17:04:32
10/1/2008 5:04:32 PM

2008-10-01T17:04:32.0000000
2008-10-01T17:04:32
2008-10-01 17:04:32Z