Re: Parse date time with fractional seconds (less than milliseconds) and time zone offset

christos_karraschristos_karras Member Posts: 50 Guru
edited December 2018 in Product Feedback - Resolved

Thanks, but there seems to be a bug or error in the documentation:

 

In your example, you used "Z". According to the example in the documentation, +00:00 should be accepted as-is:

 

Z: This pattern letter represents the time zone. This pattern letter follows the rules of the 'RFC 822 Time Zone' format type. Examples include -08:00 etc

 

However, -08:00 is not valid in RFC822, only -0800 would be valid.

 

Would it be possible to create a bug/feature request? Suggested fixes and enhancements:

* Fix the example in the documentation to replace +08:00 by +0800 so that it is valid according to RFC822

* Allow fractional seconds (sub-milliseconds) using .SSSSSSSSSSS (S repeated depending on number of digits)

* Introduce a new custom format for time zones written as +00:00 (non-RFC 822)

4
4 votes

Fixed and Released · Last Updated

9.5.0 RM-4277

Comments

  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,531 Unicorn

    Hi,

    while the problem with the time zone offset one can circumvent by using a regular expression to make the string match the standard, I would definitively support the sub milisecond resolution. In technical applications like predictive maintenance, etc, we often have nano second precision in the time stamps and multiple events per mili second. This is currently not handable by RapidMiner.

    Unfortunately this probably requires some more drastic changes as nano seconds cannot be saved as double anymore, due to limited integer range: We would always loose precision by internal rounding. All operators would need to learn how to handle that.

     

    Greetings,

     Sebastian

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
Sign In or Register to comment.