Modify ↓
Opened 5 years ago
Closed 5 years ago
#3724 closed Feature Request (Wont Fix)
_DateTimeSplit should ignore trailing Z (to accept parsing RFC3339 formated date time)
| Reported by: | matwachich@… | Owned by: | |
|---|---|---|---|
| Milestone: | Component: | Standard UDFs | |
| Version: | Severity: | None | |
| Keywords: | _DateTimeSplit RFC3339 | Cc: |
Description
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...)
Attachments (0)
Change History (4)
comment:1 Changed 5 years ago by Jos
- Type changed from Bug to Feature Request
comment:3 Changed 5 years ago by 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.
comment:4 Changed 5 years ago by Jpm
- Resolution set to Wont Fix
- Status changed from new to closed
Guidelines for posting comments:
- You cannot re-open a ticket but you may still leave a comment if you have additional information to add.
- In-depth discussions should take place on the forum.
For more information see the full version of the ticket guidelines here.
Note: See
TracTickets for help on using
tickets.
This can't be a BUG as the supported formats are clearly defined in the Helpfile.
Change it to a feature request.
Jos