0 ×

String to Date/Time (legacy)

StreamableKNIME Time Series Nodes version 4.2.0.v202003271454 by KNIME AG, Zurich, Switzerland

Parses the strings in the selected String column and converts them into date/time cells by using the entered format pattern.
Note, the date parser uses localization settings so in order to parse foreign language date formats you will need to either convert these formats to the localized representation manually, or change the localization of your system to match that of your data source.

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
Y: year that belongs to week in year
M: month in year (context sensitive)
L: month in year (standalone form)
w: Week in year
W: week in month
D: Day in year
d: day in month
F: Day of week in month
E: day (name) in week
u: day (number) in week (1 is Monday, 7 is Sunday)
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
X: ISO 8601 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.

Input Ports

: Table containing timestamp strings.

Output Ports

: Table with replaced column holding date/time cells.

Best Friends (Incoming)

String Manipulation (8 %) Streamable
String to Date/Time (legacy) (7 %) Streamable
File Reader (6 %) Streamable
String to Date&Time (5 %) Streamable
CSV Reader (4 %)
Show all 274 recommendations

Best Friends (Outgoing)

Date Field Extractor (legacy) (7 %)
Joiner (7 %)
String to Date/Time (legacy) (6 %) Streamable
Legacy Date&Time to Date&Time (6 %) Streamable
GroupBy (6 %)
Show all 344 recommendations

Workflows

01_Guided_Analytics (KNIME Hub)
01_Guided_Analytics (KNIME Hub)
01_Preprocessing_Time_Alignment_and_Visualization (KNIME Hub)
01_Preprocessing_Time_Alignment_and_Visualization (KNIME Hub)
01_Preprocessing_Time_Alignment_and_Visualization (KNIME Hub)
Show all 36 workflows

Installation

To use this node in KNIME, install KNIME Timeseries nodes from the following update site:

KNIME 4.2

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.