Duration to Number


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).

Input Ports

  1. Type: Data
    Input table.

Output Ports

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


This node is part of the extension



Short Link

Drag node into KNIME Analytics Platform