Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • String to Date&Time
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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    String To Date
    totaldataloss > Public > Upload string to forum > String To Date
  2. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    Dates – Calculate week number based on date
    mwiegand > Public > Knime Forum Support > Dates – Calculate week number based on date
  6. Go to item
    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. Go to item
    Lab 1 - 05 Date and Time Manipulations
    bojesphob > Public > Lab 1 > Lab 1 - 05 Date and Time Manipulations
  8. Go to item
    time&date_locale=de
    lukass > Forum > time&date_locale=de
  9. Go to item
    2
    lina3 > Public > Lab 5 > 2
  10. Go to item
    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
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits