ISO8601 DateTime to Timestamp fails when milliseconds not specified

[ciozi137]

Conversion fails when milliseconds are not specified in the ISO8601 DateTime String:

OK:

Not OK:

Originally posted by @ciozi137 in #11 (comment)

[ciozi137]

@francois-normandin unfortunately is not working for strict and not strict ISO 8601. And only for 3 (or more?) millisecond digits:

[ciozi137]

regex:
^([0-9]{4})-?(1[0-2]|0[1-9])-?(3[01]|0[1-9]|[12][0-9])([T])([0-9]{2}):([0-9]{2}):([0-9]{2}).([0-9]{3})(.*)

change to:
^([0-9]{4})-?(1[0-2]|0[1-9])-?(3[01]|0[1-9]|[12][0-9])([T])([0-9]{2}):([0-9]{2}):([0-9]{2})(?:.([0-9]+))?(.*)

captures the millisecond field (or not):

But then the logical OR will be False here:

so still needs a little tweaking

[ciozi137]

One more thing I noticed: there is no case for time only, which should also be allowed