0 ×

Time to String (legacy)

StreamableKNIME Time Series Nodes version 4.3.0.v202011191658 by KNIME AG, Zurich, Switzerland

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


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

Input Ports

Table containing timestamp strings.

Output Ports

Table with column holding time strings.

Best Friends (Incoming)

Best Friends (Outgoing)



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


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.


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.