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. Reading Weird Time Format
    Timestamp Conversion Time domain
    +1
    Read time format such as : 0234 --> 2 h and 34 m AM
    paolotamag > KNIME Forum Answers > Reading Weird Time Format
  3. Forum question about Date and Time Strings (43949)
    Forum question about Date and Time Strings (43949)
    mlauber71 > Forum > 2022 > kn_forum_43949_date_format
  4. 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
  5. Dates – Calculate week number based on date
    mwiegand > Public > Knime Forum Support > Dates – Calculate week number based on date
  6. Combine Date and Time
    There has been no description set for this workflow's metadata.
    simons > Public > Forum > Date&Time > Combine_Date_And_Time
  7. Lab 1 - 05 Date and Time Manipulations
    bojesphob > Public > Lab 1 > Lab 1 - 05 Date and Time Manipulations
  8. time&date_locale=de
    lukass > Forum > time&date_locale=de
  9. 2
    lina3 > Public > Lab 5 > 2
  10. 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