datediff
function (Databricks SQL)
Returns the number of days from startDate
to endDate
.
Returns
An INTEGER.
If endDate
is before startDate
the result is negative.
To measure the difference between two dates in units other than days use datediff (timestamp) function (Databricks SQL).