Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community 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
    Calculate age
    lelloba > Forum > Calculate age
    lelloba
  2. Go to item
    期間の計算-Date&Time Difference
    Japanese 日本語 Makkynm
    +5
    Date&Time Differenceの紹介用Workflowです。 期間の計算に使用します。 InputファイルはInputフォルダからダウンロードできます。 This wo…
    makkynm > Public > Intermediate > I123_DateTimeDifference
    makkynm
  3. 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
    bruno29a
  4. Go to item
    Date Add
    eamendola > Public > Date Add
    eamendola
  5. Go to item
    DateTime_Diff
    lelloba > Forum > DateTime_Diff
    lelloba
  6. Go to item
    Date&Time_Difference_Months_ERROR
    jmgor > Public > Date&Time_Difference_Months_ERROR
    jmgor
  7. Go to item
    Yesterday's date (Unix) to variable
    richardc > Public > Yesterday's date (Unix) to variable
    richardc
  8. Go to item
    fun-with-date&time-difference
    lukass > Forum > fun-with-date&time-difference
    lukass
  9. 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
    knime
  10. Go to item
    Just Knime it- CH11
    anilks > Just Knime It Challenges > Just Knime It Challenge > Just Knime it- 011
    anilks
  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