CODE EXAMPLE FOR SQL

MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES

To count the difference between dates in MySQL, use the DATEDIFF(enddate, startdate) function. The difference between startdate and enddate is expressed in days.