Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • String to Duration
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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Calculate week start and end
    elsamuel > Public > Calculate week start and end
    elsamuel
  2. Go to item
    Idle Time Calculator
    elsamuel > Public > Idle Time Calculator
    elsamuel
  3. Go to item
    Date conversion-ADR
    adrix > Public > workflow_HUB > Date conversion-ADR
    adrix
  4. Go to item
    Duration to time format
    Duration Time Timestamp
    Duration to time format
    mlauber71 > Forum > 2021 > kn_forum_38395_duration_to_time_format
    mlauber71
  5. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    [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. Go to item
    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
  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
Talacker 50
8001 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 Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits