How can we know the number of days between two given dates
using MySQL?
Answer Posted / sergii
DATEDIFF(expr1,expr2)
DATEDIFF() returns expr1 – expr2 expressed as a value in
days from one date to the other. expr1 and expr2 are date
or date-and-time expressions. Only the date parts of the
values are used in the calculation.
mysql> SELECT DATEDIFF('1997-12-31 23:59:59','1997-12-30');
-> 1
mysql> SELECT DATEDIFF('1997-11-30 23:59:59','1997-12-31');
-> -31
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How do I find mysql database?
What is myisamchk?
What are the steps required to view your mysql database?
How do I find users in mysql?
Is mysql same as mariadb?
Why we use mysql workbench?
How do I download mysql on my laptop?
How do I rename a table in mysql?
How to use like conditions?
explain GROUPBY & HAVING clause with examples.
Is there a way to see the files which are stored?
What is flush privileges in mysql?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
What is mysql default port number?
What is tee command in mysql?