Interested to Buy Any Domain ? << Click Here >> for more details...
How can we know the number of days between two given dates
using MySQL?
- 2 Answers
- 7685 Views
- Base2 Infotech, Webworks, I also Faced
- E-Mail Answers
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 regex in mysql?
What language is mysql written in?
What is mysqli_connect_error ()?
How do I stop a mysql service?
What is cursor in mysql?
What are the differences between innodb and myisam engines?
How do I create a mysql username and password?
What is strict mode in mysql?
How do I copy a table in mysql workbench?
What is normalization and list the different types of normalization?
How to display top 50 rows?
How do you shutdown a mysql database?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
What is unique key in mysql?
Can a table have multiple primary keys?
