Question

How can I Know the number of days between two given dates using MySQL?

Comments

Try datediff (refer: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_datediff )

Answer 1

The following function can be used to calculate number of days between two dates.
SELECT DATEDIFF("2014-06-02","2014-01-01");