Answers for "current date sql and database record date diffence 5 in mysql"

SQL
7

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
Posted by: Guest on May-22-2020
0

mysql filter based on datediff

SELECT *
FROM myTable
WHERE birthdate >= 'date1' AND death <= 'date2' AND age > 17 AND age < 55;
Posted by: Guest on October-31-2020

Code answers related to "current date sql and database record date diffence 5 in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language