TimeDiff
TimeDiff( start, finish, unit )
TimeDiff( start, finish, unit )
time_diff( start, finish, unit )
TimeDiff( start, finish, unit )
Description
The TimeDiff
function returns the time difference between start
and finish
, expressed in unit
units. The difference includes start
but excludes finish
.
Parameters
Parameter | Type | Definition and Requirements |
---|---|---|
|
Date or Timestamp |
The starting Date or Timestamp. |
|
Date or Timestamp |
The ending Date or Timestamp. |
|
String |
The type of unit that the difference should be expressed in. When When
|
Examples
The following query demonstrates several time differences:
[18449 36899 442788 26567314 1594038896 1594038896789]
[ 18449, 36899, 442788, 26567314, 1594038896, 1594038896789 ]
[18449, 36899, 442788, 26567314, 1594038896, 1594038896789]
[ 18449, 36899, 442788, 26567314, 1594038896, 1594038896789 ]
Is this article helpful?
Tell Fauna how the article can be improved:
Visit Fauna's forums
or email docs@fauna.com
Thank you for your feedback!