How can we know the number of days between two given dates
using MySQL?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shwetha
There is a operator {not} BETWEEN ,we can use this in where
clause to get in between dates.
ex:
select count(column name)
from table1
where dates BETWEEN '01-jul-04' and '01-jul-05';
Is This Answer Correct ? | 4 Yes | 4 No |
What is a procedure example?
Is mysqli faster than mysql?
Can mongodb replace mysql?
How to write date and time literals?
How to filter data from a mysql database table with php?
What is the maximum size of table in mysql?
What is longblob in mysql?
Explain advantages of MyISAM over InnoDB?
Does mysql support nosql?
How can you add and remove any column of a table?
What is 'mysqladmin' in mysql?
How to display top 50 rows?