How To Calculate the Difference between Two Dates

Q

How To Calculate the Difference between Two Dates? - MySQL FAQs - Introduction to SQL Date and Time Handling

✍: FYIcenter.com

A

If you have two dates, and you want to know how many days between them, you can use the DATEDIFF(date1, date2) function as shown below:

SELECT DATEDIFF(DATE('1997-02-28'), DATE('1997-03-01'))
   FROM DUAL;
   -1

2007-05-11, 4791👍, 0💬