How can we know the number of days between two given dates
using MySQL?
Answer Posted / 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 |
Post New Answer View All Answers
List data types in mysql? Explain
What is delimiter in mysql?
How we get sum of column.
What are the different types of triggers in mysql?
What is mysqli_result?
What is InnoDB?
What is striped backup
How to set mysql variable in php?
How do I install the latest mysql on ubuntu?
Explain the architecture models of SQL Server?
What is blob and text in mysql?
What is a left join mysql?
How do I start mysql from command line?
How large can a mysql database become?
How MySQL Optimizes DISTINCT?