diff date mysql code example

Example 1: mysql date diff

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

Example 2: compare date mysql

SELECT *
FROM players
WHERE DATE(us_reg_date) BETWEEN '2000-07-05' AND '2011-11-10'