regex101: Match many cases of 8601

^start of line

Group year(?<year>\d{4})

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

Character Class[-\/]

-the literal - (45₁₀ / 55₈ / 2D₁₆)

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

Group month(?<month>0[1-9]|1[0-2])

1st Alternative0[1-9]

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

Character Class[1-9]

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

2nd Alternative1[0-2]

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

Character Class[0-2]

0-2one character from 0 (48₁₀) to 2 (50₁₀)

Character Class[-\/]

-the literal - (45₁₀ / 55₈ / 2D₁₆)

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

Group day(?<day>0[1-9]|[1-2][0-9]|3[0-1])

1st Alternative0[1-9]

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

Character Class[1-9]

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

2nd Alternative[1-2][0-9]

Character Class[1-2]

1-2one character from 1 (49₁₀) to 2 (50₁₀)

Character Class[0-9]

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

3rd Alternative3[0-1]

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

Character Class[0-1]

0-1one character from 0 (48₁₀) to 1 (49₁₀)

Non-Capturing Group(?:[T\s](?:(?<hour>0[0-9]|1[0-9]|2[0-4]):(?<minute>\d{2}):(?<second>\d{2})(?:\.(?<nano>\d+))?))?

?repeats the group contents below at most once:

Character Class[T\s]

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

\sany whitespace character

Non-Capturing Group(?:(?<hour>0[0-9]|1[0-9]|2[0-4]):(?<minute>\d{2}):(?<second>\d{2})(?:\.(?<nano>\d+))?)

Group hour(?<hour>0[0-9]|1[0-9]|2[0-4])

1st Alternative0[0-9]

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

Character Class[0-9]

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

2nd Alternative1[0-9]

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

Character Class[0-9]

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

3rd Alternative2[0-4]

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

Character Class[0-4]

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

Group minute(?<minute>\d{2})

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

Group second(?<second>\d{2})

Non-Capturing Group(?:\.(?<nano>\d+))?

Non-Capturing Group(?:(?<offset>[Zz]|(?:[+-])(?:[01]\d|2[0-3])(?::?[0-5]\d)?)?)

$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

27 tokens

Regular Expression

^(?<year>\d{4})[-\/](?<month>0[1-9]|1[0-2])[-\/](?<day>0[1-9]|[1-2][0-9]|3[0-1])(?:[T\s](?:(?<hour>0[0-9]|1[0-9]|2[0-4]):(?<minute>\d{2}):(?<second>\d{2})(?:\.(?<nano>\d+))?))?(?:(?<offset>[Zz]|(?:[+-])(?:[01]\d|2[0-3])(?::?[0-5]\d)?)?)$

New

2020-12-01T12:13:51.123+02:00
2020-12-01T12:13:51.123+0200
2020-12-01T12:13:51.123Z
2020-12-01T12:13:51.123
2020-12-01T12:13:51.123341512+02:00
2020-12-01T12:13:51.123341512+0200
2020-12-01T12:13:51.123341512Z
2020-12-01T12:13:51.123341512
2020-12-01T12:13:51+02:00
2020-12-01T12:13:51+0200
2020-12-01T12:13:51Z
2020-12-01T12:13:51
2020-12-01 12:13:51.123 +02:00
2020-12-01 12:13:51.123 +0200
2020-12-01 12:13:51.123Z
2020-12-01 12:13:51.123
2020-12-01 12:13:51.123341512 +02:00
2020-12-01 12:13:51.123341512 +0200
2020-12-01 12:13:51.123341512Z
2020-12-01 12:13:51.123341512
2020-12-01 12:13:51+02:00
2020-12-01 12:13:51+0200
2020-12-01 12:13:51Z
2020-12-01 12:13:51
2020-12-01+02:00
2020-12-01+0200
2020-12-01Z
2020-12-01
2020/12/01T12:13:51.123+02:00
2020/12/01T12:13:51.123+0200
2020/12/01T12:13:51.123Z
2020/12/01T12:13:51.123
2020/12/01T12:13:51.123341512+02:00
2020/12/01T12:13:51.123341512+0200
2020/12/01T12:13:51.123341512Z
2020/12/01T12:13:51.123341512
2020/12/01T12:13:51+02:00
2020/12/01T12:13:51+0200
2020/12/01T12:13:51Z
2020/12/01T12:13:51
2020/12/01+02:00
2020/12/01+0200
2020/12/01Z
2020/12/01
2039/15/23
2923/09/12
2023/23/51
2020-12-01T00:13:51
2020-12-01T01:13:51
2020-12-01T10:13:51
2020-12-01T19:13:51
2020-12-01T20:13:51
2020-12-01T24:13:51

Extraction

date= $year-$month-$day | time = $hour:$minute:$second.$nano | Offset:$offset\n