Regular Expressions 101

Pro

Group 1((?P<fulldate>(?P<date>(\d{4}-\d{2}-\d{2}))T(?P<time>(\d{2}:\d{2}:\d{2}(?:\.\d+)?)))(?P<tz>(Z|[\+-]\d{2}:\d{2})?))

Group fulldate(?P<fulldate>(?P<date>(\d{4}-\d{2}-\d{2}))T(?P<time>(\d{2}:\d{2}:\d{2}(?:\.\d+)?)))

Group date(?P<date>(\d{4}-\d{2}-\d{2}))

Group 4(\d{4}-\d{2}-\d{2})

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

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

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

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

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

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

Group time(?P<time>(\d{2}:\d{2}:\d{2}(?:\.\d+)?))

Group 6(\d{2}:\d{2}:\d{2}(?:\.\d+)?)

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

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

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

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

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

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

?repeats the group contents below at most once:

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

\d+a Unicode decimal digit, repeated at least once

Group tz(?P<tz>(Z|[\+-]\d{2}:\d{2})?)

Group 8(Z|[\+-]\d{2}:\d{2})?

?repeats the group contents below at most once:

1st AlternativeZ

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

2nd Alternative[\+-]\d{2}:\d{2}

Character Class[\+-]

\+the literal + (43₁₀ / 53₈ / 2B₁₆)

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

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

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

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

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

Detailed match information will be displayed here automatically.

25 tokens

((?P<fulldate>(?P<date>(\d{4}-\d{2}-\d{2}))T(?P<time>(\d{2}:\d{2}:\d{2}(?:\.\d+)?)))(?P<tz>(Z|[\+-]\d{2}:\d{2})?))

New

CAST(N'2016-01-19T15:21:32.59+02:00'