The Date Diff action calculates the
difference between two TIMESTAMP variables. This is useful
for time processing when you want to determine the
difference between two timestamps; for example, you need to skip an update if the required operation is
performed. The results of the calculated difference are
always positive (unsigned) numbers.
Input tab
| Parameter | Description |
|---|---|
| First Date | The input variable to use as the first TIMESTAMP. |
| Second
Date
|
The input variable to use as the
second TIMESTAMP. |
Output tab
The Output tab provides the variables
to hold the result values for the Date
Diff action.
| Parameter | Description |
|---|---|
| Total Seconds | The output variable that will hold the total number of seconds. |
| Total Milliseconds | The output variable that will hold the total number of milliseconds. |
| Days | The output variable that will hold the number of days. |
| Hours | The output variable that will hold the number of hours. |
| Seconds | The output variable that will hold
the number of seconds. |
| Milliseconds | The output variable that will hold
the number of milliseconds. |