MySQL Function Reference

Returns the difference in days between dates. When calculating the difference, the date is used, the time is not used

DATEDIFF(datetime1, datetime2)

SELECT DATEDIFF('2022-12-05', '2022-12-01')