Calculating the Difference between Two Dates in MySQL

Q

How To Calculate the Difference between Two Dates in MySQL?

✍: 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

 

Introduction to Date and Time Handling in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 176👍, 0💬