The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

"Not a Bug With Date_time"

wesselwessel Member Posts: 537 Maven
edited May 2019 in Help
Hey,

I found out that Rapid Miner has a weird quirk.
It puts a 00, where it should put a 12.
Using the nominal to date operator, with yyyy-MM-dd hh:mm:ss as time format.

To fix this you have to use yyyy-MM-dd kk:mm:ss

http://www.few.vu.nl/~wln320/machine/rapid%20miner%20bug.gif
image

Best regards,

Wessel
Tagged:

Answers

  • IngoRMIngoRM Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    Hi Wessel,

    this is actually the desired behaviour and not a bug as far as I can see. From the operator's manual:
    • H: hour in day (0-23); Number; example: 0
    • k: hour in day (1-24); Number; example: 24
    • K: hour in am / pm (0-11); Number; example: 0
    • h: hour in am / pm (1-12); Number; example: 12
    As you can see, the "h" as it was used in your first try is used for parsing numbers between 1-12 where 12 am corresponds to 00 in 24-hour format. If your data actually contains 24 hour dates you will have to use either "H" or "k" depending on the first counted number as stated above.

    This is actually directly taken from Java date parsing. More information can be found at

    http://download.oracle.com/javase/1.5.0/docs/api/java/text/SimpleDateFormat.html

    Hope that helps,
    Ingo
  • wesselwessel Member Posts: 537 Maven
    Hey Ingo,

    You are right it is not a bug.
    I called it a weird quirk because I did not understand it and it was given me a lot of trouble.
    Now that I do understand it, it all makes sense, and this post isn't really necessary.
    But the understanding came after that I posted it :)

    Best regards,

    Wessel
  • IngoRMIngoRM Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    Hi,

    I only just realized that the topic subject started with "Not a bug..." - sorry for the confusion. However, maybe this thread can help others if they stumble upon the same phenomenon.

    Cheers,
    Ingo
Sign In or Register to comment.