Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Date Time Formatting UTC
JEdward
RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 578 Unicorn
Hi,
I'm trying to import a column of times in the format
Currently RapidMiner uses SimpleDateFormat for the date formatting http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html
but I'm struggling to work out how to implement it for the above values. It's the ISO 8601 datetime format so I had thought it would be pretty straightforward http://www.w3.org/TR/NOTE-datetime
I have tired the patterns
yyyy-MM-dd'T'HH:mm:ss.SSSZ (this works for 1,3 & 4 but fails on 2)
yyyy-MM-dd'T'HH:mm:ss.SZ (this fails on all)
yyyy-MM-dd'T'HH:mm:ss.Sz (this fails on all)
Anyone have any ideas?
I'm trying to import a column of times in the format
1 | 2014-09-01T14:30:12:123Z |
2 | 2014-09-01T14:32:13:33Z |
3 | 2014-09-01T14:12:12:523Z |
4 | 2014-09-01T14:23:12:323Z |
but I'm struggling to work out how to implement it for the above values. It's the ISO 8601 datetime format so I had thought it would be pretty straightforward http://www.w3.org/TR/NOTE-datetime
I have tired the patterns
yyyy-MM-dd'T'HH:mm:ss.SSSZ (this works for 1,3 & 4 but fails on 2)
yyyy-MM-dd'T'HH:mm:ss.SZ (this fails on all)
yyyy-MM-dd'T'HH:mm:ss.Sz (this fails on all)
Anyone have any ideas?
0
Answers
yyyy-MM-dd'T'HH:mm:ss.S works however I have a new value that's throwing errors.
2014-07-08T14:20:52Z
In this example as the event happened exactly on .000 the server has removed all the numbers that it deems unnecessary.
I need to therefore work out how to be a bit more flexible with this. Arrgh!! )
I'm leaving this open for now as this only works for UTC dates so if you have any other dates (or a better way of doing it than two loop attributes) let me know below.