Hub
NodeNode / Manipulator

String to Date&Time

Other Data Types Time Series Transform Streamable
Drag & drop
Like
Copy short link

Parses the strings in the selected columns and converts them into Date&Time cells. The expected format can be selected from a number of commonly used formats or specified manually (see section "Type and Format Selection").

Since dates may contain localized terms such as month or weekday names, you can additionally specify a locale.

Node details

Input ports
  1. Type: Table
    Input table
    Input table.
Output ports
  1. Type: Table
    Output table
    Output table containing the parsed columns.

Extension

The String to Date&Time node is part of this extension:

Related workflows & nodes

  1. String To Date
    totaldataloss > Public > Upload string to forum > String To Date
  2. Date String Conversion Without Leading Zeroes
    Date
    This workflow demonstrates how you can ingest string-formatted dates that may not have le…
    scottf > Public > ForumWorkflows > 2019 > 10 > StringConversionWithoutLeadingZeroes
  3. Dates – Calculate week number based on date
    mwiegand > Public > Knime Forum Support > Dates – Calculate week number based on date
  4. Combine Date and Time
    There has been no description set for this workflow's metadata.
    simons > Public > Forum > Date&Time > Combine_Date_And_Time
  5. Lab 1 - 05 Date and Time Manipulations
    bojesphob > Public > Lab 1 > Lab 1 - 05 Date and Time Manipulations
  6. time&date_locale=de
    lukass > Forum > time&date_locale=de
  7. 2
    lina3 > Public > Lab 5 > 2
  8. 02 Reading Text Data
    Text mining Text processing Pdf
    +4
    L4-TP SELF-PACED COURSE exercise. Encapsulate text and its metainformation from strings t…
    mcmas1999 > Assignments > Lab 05 > Custom Data Exercises > 02 Reading Text Data
  9. convertdate
    daniel_weikert > Public > daniel_weikert_convert_date_to_us_format
  10. LinePlotSample
    marysim > Public > LinePlotSample