Hub
NodeNode / Manipulator

String to Duration

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

Converts string cells to duration cells. The string representation of these durations needs to be in either the ISO-8601 representation (see date-based duration format or time-based duration format for details, e.g. 'P2Y3M1D'), the short letter representation (e.g. '2y 3M 1d'; Date-based duration: y: years, M: months, d: days; Time-based duration: H: hours, m: minutes, s: seconds) or the long word representation (e.g. '2 years 3 months 1 day').

Node details

Input ports
  1. Type: Table
    Input table
    Input table.
Output ports
  1. Type: Table
    Output table
    Output table with duration columns.

Extension

The String to Duration node is part of this extension:

Related workflows & nodes

  1. Calculate week start and end
    elsamuel > Public > Calculate week start and end
    elsamuel
  2. Idle Time Calculator
    elsamuel > Public > Idle Time Calculator
    elsamuel
  3. Date conversion-ADR
    adrix > Public > workflow_HUB > Date conversion-ADR
    adrix
  4. Duration to time format
    Duration Time Timestamp
    Duration to time format
    mlauber71 > Forum > 2021 > kn_forum_38395_duration_to_time_format
    mlauber71
  5. SAS Date Conversion
    Date&Time SAS to KNIME Data Manipulation
    +1
    This workflow demonstrates the use of "SAS Date to KNIME Conversion" Component. SAS7BDAT …
    ipazin > Public > SAS Date Conversion
    ipazin
  6. Google Big Query meets SQLite. The business of baseball games.
    Databases Google Big Query Big Query
    +7
    This workflow graphically explores attendance at baseball games together with weather con…
    knime > Examples > 01_Data_Access > 02_Databases > 10_GoogleBigQuery_meets_SQLite
    knime
  7. Google Big Query meets SQLite. The business of baseball games.
    Databases Google Big Query Big Query
    +7
    This workflow graphically explores attendance at baseball games together with weather con…
    haoran > Public > 01_Data_Access > 02_Databases > 10_GoogleBigQuery_meets_SQLite
    haoran
  8. 02 Data Quality Assessment
    Data drift Synthetic data Model monitoring
    This workflow service is meant to be called by an external workflow. It carries out the D…
    emilio_s > Blogposts > Data Drift > 02 Data Quality Assessment
    emilio_s
  9. [KNIME Nodes] KN-302 Advanced Demand Forecasting Neural Networks
    Neural Network Deep Learning Kaggle
    Provides a Neural Network solution to the Kaggle Store Item Demand Forecasting Challenge.…
    scientificstrategy > Public > KNIME Nodes > KN-302 Advanced Demand Forecasting Neural Networks v05
    scientificstrategy
  10. Guided Automation
    AutoML Guided analytics Automated machine learning
    +11
    Download the entire workflow group from the Example Server. This Guided Analytics applica…
    knime > Examples > 50_Applications > 36_Guided_Analytics_for_ML_Automation > 01_Guided_Analytics_for_ML_Automation > 01_Guided_Analytics_for_ML_Automation
    knime