dateDiff()

Overview

The dateDiff() function calculates the time interval in the specified unit between two given time values (end_time - start_time) and returns the integer part of the interval.

Syntax

dateDiff(end_time, start_time, unit)

Augment	Type	Description
`end_time`	Datetime, timestamp, string	The end time
`start_time`	Datetime, timestamp, string	The start time
`unit`	string	The unit of the interval, which can be set as `day`, `hour`, `minute`, or `second`

Return type: Integer

Example of Result

UQL
return dateDiff("1970-01-01 10:00:00", "1970-01-01 12:00:20", "minute")

Result: -120

Example of Use

Retrieve employees who have worked for over 730 days.

UQL
find().nodes({@employee}) as e
where dateDiff(now(), e.startDate, "day") > 730
return table(e.name, e.startDate) order by e.startDate