Mysql date difference in days

MySQL DATEDIFF() returns the number of days between two dates or datetimes.

Syntax :

DATEDIFF(date1,date2);

Example:

SELECT DATEDIFF('2017-03-31','2017-01-01');

Result: