Premium
Log in
SQL Function Reference
DATEDIFF
Returns the difference in days between dates. When calculating the difference, the date is used, the time is not used
DATEDIFF(datetime1, datetime2)Examples
SELECT DATEDIFF('2022-12-05','2022-12-01')DATEDIFF(datetime1, datetime2)SELECT DATEDIFF('2022-12-05','2022-12-01')