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
What is pragma exception?
What is a join? Explain the different types of mysql joins.
What is text?
Is mysql free for enterprise?
How do I find mysql version in mysql workbench?
What are the limitations of mysql?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
What is a text delimiter?
List some mysql advantages and disadvantages?
What are the different tables present in MySQL?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
How do I change global variables in mysql?
In how many ways we can retrieve data in the result set of mysql using php?
Why do we need mysql?
What is pdo mysql?