Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Duration to Number
NodeNode / Manipulator

Duration to Number

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

Converts a duration to the selected field and appends the value as a long or double column. Valid fields are hours, minutes, seconds, nano-, micro- and milliseconds. If the output should be a long value the conversion result will be truncated, e.g. if the duration 1 hour 30 minutes should be converted to hours, the exact output is 1.5 hours whereas the truncated output 1 hour .

Note: Only time-based durations can be converted to numbers, since the conversion of date-based durations is not well defined (e.g. it is not clearly defined how many days a month has).

Node details

Input ports
  1. Type: Table
    Input table
    Input table.
Output ports
  1. Type: Table
    Output table
    Output table containing the converted field as appended column (either long or double).

Extension

The Duration to Number node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. 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
  2. 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…
    mortenrai > Public > 01_Guided_Analytics_for_ML_Automation
    mortenrai
  3. 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…
    bgriff > Public > 01_Guided_Analytics_for_ML_Automation
    bgriff
  4. 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…
    prashantks > Public > 01_Guided_Analytics_for_ML_Automation
    prashantks
  5. 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…
    ealbuger > Public > 01_Guided_Analytics_for_ML_Automation
    ealbuger
  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