datediff
function
Applies to: Databricks SQL preview Databricks Runtime 11.3 LTS and above
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.