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.
Time to String
Converts the time values in the timestamp column into string using
the selected or entered conversion pattern as defined by
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
Dialog Options
- Column containing date/time
-
Select the input column containing the date/time.
- Replace selected column
- If checked the selected date/time
column will be replaced by a column containing the time values as
strings.
- New column name
- If the column should not be replaced
enter here the name of the new column.
- Date format:
- Enter the conversion pattern as defined by
SimpleDateFormat
Ports
Input Ports
0 |
Table containing timestamp strings. |
Output Ports
0 |
Table with column holding time strings. |
This node is contained in KNIME Time Series Nodes
provided by KNIME GmbH, Konstanz, Germany.