0 ×

String to Date&Time

StreamableKNIME Date and Time Handling version 4.2.1.v202007310802 by KNIME AG, Zurich, Switzerland

Parses the strings in the selected columns and converts them into Date&Time cells using the provided format pattern.
Since dates may contain localized terms such as month or weekday names, you can select a locale.

Options

Column Selection

Column Selector
Only the included columns will be parsed.

Replace/Append Selection

Append selected columns
The selected columns will be appended to the input table. The suffix of the appended columns can be provided in the text field to the right.
Replace selected columns
The selected columns will be replaced by the converted columns.

Type and Format Selection

New type
The type of the new data cells can be selected.
Date format
A format string (defined by DateTimeFormatter ).
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"
  • "yyyy-MM-dd'T'HH:mm:ss.SSSXXX'['VV']'" parses dates like "2001-07-04T12:08:56.235+02:00[Europe/Berlin]"
If there is e.g. a time column which has both times with and without milliseconds, optional parts in the format can be specified with square brackets. Examples:
  • "HH:mm:ss[.SSS]" parses times like "12:08:56.123" and "12:08:56"
  • "yyyy-MM-dd'T'HH:mm[:ss[.SSS]]" parses dates like "2001-07-04T12:08:56.235", "2001-07-04T12:08:56" and "2001-07-04T12:08"
Supported placeholders in the pattern are:
  • G: era
  • u: year
  • y: year of era
  • D: day of year
  • M: month in year (context sensitive)
  • L: month in year (standalone form)
  • d: day of month
  • Q: quarter of year
  • q: quarter of year
  • Y: week based year
  • w: week of week based year
  • W: week of month
  • E: day of week
  • e: localized day of week
  • c: localized day of week
  • F: week of month
  • a: am/pm of day
  • h: clock hour of am/pm (1-12)
  • K: hour of am/pm (0-11)
  • k: clock hour of am/pm (1-24)
  • H: hour of day (0-23)
  • m: minute of hour
  • s: second of minute
  • S: fraction of second
  • A: milli of day
  • n: nano of second
  • N: nano of second
  • V: time zone ID
  • z: time zone name
  • O: localized zone offset
  • X zone offset ('Z' for zero)
  • x: zone offset
  • Z: zone offset
  • p: pad next
  • ' : escape for text
  • '': single quote
  • [: optional section start
  • ]: optional section end
Locale
A locale can be chosen, which determines the language and geographic region for terms such as months or weekdays.
Content of the first cell
Shows the content of the first non-missing cell of the first included column to simplify format selection.
Guess data type and format
If pressed the data type and the format are guessed based on the content of the first cell. If none of the formats in the list is suitable, type and format will not change.

Abort Execution

Fail on error
If checked, the node will abort the execution and fail on errors. If unchecked, missing values will be generated instead.

Input Ports

Icon
Input table.

Output Ports

Icon
Output table containing the parsed columns.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

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

KNIME 4.2

A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped update site.

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.

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.