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
What is the difference between now() and current_date()?
What is “i_am_a_dump” flag in mysql?
How do I change the max connections in mysql?
Is mysql good for big data?
How do I completely remove mysql from windows?
What are the types of queries?
What is the datatype of image?
What is a data directory?
How do I exit mysql?
How to return query output in html format?
How many columns is too many mysql?
How do I download mysql?
Restore database (or database table) from backup.
What is index length in mysql?
What is mysql command line?