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


Please Help Members By Posting Answers For Below Questions

List data types in mysql? Explain

658


What is delimiter in mysql?

643


How we get sum of column.

714


What are the different types of triggers in mysql?

678


What is mysqli_result?

690


What is InnoDB?

762


What is striped backup

2004


How to set mysql variable in php?

677


How do I install the latest mysql on ubuntu?

684


Explain the architecture models of SQL Server?

2079


What is blob and text in mysql?

804


What is a left join mysql?

656


How do I start mysql from command line?

713


How large can a mysql database become?

694


How MySQL Optimizes DISTINCT?

792