TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)

SELECT TIMESTAMPDIFF(day,'2019-06-19','29-07-2009');