How To Calculate the Difference between Two Dates? | MySQL Interview Questions

If you have two dates, and you want to know how many days between them, you can use the DATEDIFF(datel, date2) function as shown below:
SELECT DATEDI FF( DATE(’1997-02-28’), DATE(’1997-03-01’))
FROM DUAL;
-1 and different between two time is TIMEDIFF()