Home » Frequently Asked Questions » MySQL Interview Questions

How can we know the number of days between two given dates using MySQL?

Using DATEDIFF()

SELECT DATEDIFF(NOW(),'2007-07-15');

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Copy the characters (respecting upper/lower case) from the image.