_DateTimeSplit should ignore trailing Z (to accept parsing RFC3339 formated date time)

[matwachich@…]

When passing a RFC3339 formated date-time string to _DateTimeSplit, the seconds are ignored.

_DateTimeSplit("2019-03-07T20:31:30Z", $aDate, $aTime)
Returns correct $aDate, but $aTime[3] = 0

Solutions:

• StringLeft($sDateTime, 19)
• Or make a more complete function that will completely support RFC3339 date-time (with miliseconds/nanoseconds...)

[Jos]

This can't be a BUG as the supported formats are clearly defined in the Helpfile.
Change it to a feature request.

Jos

[TicketCleanup]

Automatic ticket cleanup.

[jchd18]

Modifying the various date/time functions for full compliance to the RFC would be a huge and difficult task leading to a number of script-breaking changes. Rigourous handling of timestamps is populated by hords of venimous worms, whatever language you use.

If your application requires handling anything not covered by the current simple implementation, I'd advise to write a UDF covering a wider range of formats.