Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Date&Time Difference
NodeNode / Manipulator

Date&Time Difference

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

Calculates differences between two date&time cells and appends a new column. The output can be either a duration or a selected granularity (years, months, weeks, days, hours, minutes, seconds, millis, nanos). It can be configured to use as second date&time either a second column, the execution date&time, a selected fixed date&time or the date&time contained in the previous row.

Node details

Input ports
  1. Type: Table
    Input table
    Input table.
Output ports
  1. Type: Table
    Output table
    Output table containing an appended column with the calculated differences.

Extension

The Date&Time Difference node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    期間の計算-Date&Time Difference
    Japanese 日本語 Makkynm
    +5
    Date&Time Differenceの紹介用Workflowです。 期間の計算に使用します。 InputファイルはInputフォルダからダウンロードできます。 This wo…
    makkynm > Public > Intermediate > I123_DateTimeDifference
  2. Go to item
    Get number of days between dates of current and previous row
    bruno29a > Public > Forum > Get number of days between dates of current and previous row
  3. Go to item
    Date Add
    eamendola > Public > Date Add
  4. Go to item
    Yesterday's date (Unix) to variable
    richardc > Public > Yesterday's date (Unix) to variable
  5. Go to item
    fun-with-date&time-difference
    lukass > Forum > fun-with-date&time-difference
  6. Go to item
    Challenge 11 - Mean Time to Close a Ticket - Solution
    Date&Time Data Wrangling Justknimeit
    +1
    Your support team would like to get some insight into the quality of their service and th…
    knime > Just KNIME It! > Challenge 11 - Mean Time to Close a Ticket - Solution
  7. Go to item
    Just Knime it- CH11
    anilks > Public > Just Knime It Challenge > Just Knime it- CH11
  8. Go to item
    KNIME_Challenge11_Tkt_Mean_Time
    lenexa_jayhawk > Public > KNIME_Challenge11_Tkt_Mean_Time
  9. Go to item
    Calculate date difference between each row of CarID
    bruno29a > Public > Forum > Calculate date difference between each row of CarID
  10. Go to item
    KNIME_Process Mining_Throughput Time Calculation
    f_lisse > Process Mining > Throughput Time Calculation
  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