MySQL Knowledge Base

DATEDIFF()

Calculate difference between the current date and another date:

SELECT DATEDIFF(CURDATE(), start_date) AS stay_length FROM $whichTable