Check out example codes for "mysql date diff". It will help you in understanding the concepts better.

Code Example 1

SELECT DATEDIFF(expr1,expr2) as difference_in_days;


select DATEDIFF('2020-05-15', '2020-05-10'); //returns 5
select DATEDIFF('2020-05-13', '2020-05-16'); //returns -3
select DATEDIFF('2020-06-30', '2020-05-30'); //returns 30

Code Example 2

#Get date diff in days
select DATEDIFF('2020-04-13', '2020-04-20');#returns -7
select DATEDIFF('2020-04-20', '2020-04-13');#returns  7

Code Example 3

#Get date diff in days
select DATEDIFF(date1, date2) from table;

Learn ReactJs, React Native from akashmittal.com