The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at
http://knime.com.
String to Date/Time
Parses the strings in the selected String column and converts them
into date/time cells by using the entered format pattern.
Dialog Options
- Select column
-
Select the input column containing the timestamp string.
- Replace selected column
-
Check if the string column is not needed anymore and should be
replaced by the parsed and converted date/time values.
- New column name
-
If the string column should not be replaced enter here the name for
the new column containing the parsed and converted date/times.
- Date format
-
A format string as required by the java.text.SimpleDateFormat.
Examples:
- "yyyy.MM.dd HH:mm:ss.SSS" parses dates like "2001.07.04 12:08:56.000"
- "yyyy-MM-dd'T'HH:mm:ss.SSSZ" parses dates like "2001-07-04T12:08:56.235-0700"
Valid pattern elements are:
- G: era designator
- y: year
- M: month in year
- w: Week in year
- W: week in month
- D: Day in year
- d: day in month
- F: Day of week in month
- E: day in week
- a: Am/pm marker
- H: hour in day (0-23)
- k: hour in day (1-24)
- K: hour in am/pm (0-11)
- h: hour in am/pm (1-12)
- m: minute in hour
- s: Second in minute
- S: millisecond
- z: Timezone (General time zone)
- Z: RFC 822 time zone
- Abort execution
- If checked the node will abort the
execution after the maximum number of unparsable rows is reached.
Check in order to test whether the entered
pattern can be applied to the input data.
- Maximum number of unresolved rows
-
The maximum number of rows where the dates could not be parsed with
the entered pattern before the node cancels its execution.
Ports
Input Ports
0 |
Table containing timestamp strings. |
Output Ports
0 |
Table with replaced column holding date/time cells. |
This node is contained in KNIME Time Series Nodes
provided by KNIME GmbH, Konstanz, Germany.