Time to String (legacy)

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"

• 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

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

Views

This node has no views

Workflows

• 01_Model_FactoryKNIME Hub
• 03_Applying_Text_and_Network_Analysis_Techniques_to_ForumsKNIME Hub
• Applying_Text_and_Network_Analysis_Techniques_to_ForumsKNIME Hub
• CV_BuilderNodePit Space
• CV_BuilderKNIME Hub
• Show all 8 workflows

Links

• Current date formatby armingrudd on 2020-01-11

  forum.knime.com/p/78535

Developers