"Not a Bug With Date_time"

wessel

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


Best regards,

Wessel

IngoRM

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