Rapidminer Date Time formatting with the Nominal to Date Operator
What on earth is “MM dd, yyyy”?
Parsing your date and/or times from the default nominal text string can be a daunting task. It doesn’t have to be.
Using our Nominal to Date operator can be very simple if you know where to start.
The Nominal to Date operator converts the selected nominal attribute of the input ExampleSet into the selected date and/or time type. The attribute is selected by the attribute name parameter. The type of the resultant date and/or time attribute is specified by the date type parameter. The nominal values are transformed into date and/or time values. This conversion is done with respect to the specified date format string that is specified by the date format parameter.
It is important to note that the old nominal attribute will be removed and replaced by a new date and/or time attribute if the keep old attribute parameter is not set to true.
The given date and time are 2001-07-04 12:08:56 local time in the U.S. Pacific Time time zone, here are some examples for parsing the ways that date can be formatted in your data set
- 'yyyy.MM.dd G 'at' HH:mm:ss z': 2001.07.04 AD at 12:08:56 PDT
- 'EEE, MMM d, yy': Wed, Jul 4, '01
- 'h:mm a': 12:08 PM
- 'hh 'oclock' a, zzzz': 12 oclock PM, Pacific Daylight Time
- 'K:mm a, z': 0:08 PM, PDT
- 'yyyy.MMMMM.dd GGG hh:mm aaa': 2001.July.04 AD 12:08 PM
- 'EEE, d MMM yyyy HH:mm:ss Z': Wed, 4 Jul 2001 12:08:56 -0700
To learn more about the Nominal to Date Operator check out our documentation site - Nominal To Date Operator Documentation