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
- 7709 Views
- Base2 Infotech, Webworks, I also Faced
- E-Mail Answers
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 latest mysql version?
How many rows mysql can handle?
How to delete an existing column in a table?
How do I create a new database in mysql?
How set mysql root password?
How do I zip a file in mysql?
Is mysql query case sensitive?
How do I quit mysql?
How to create a trigger in mysql?
Which datatype is used for email in mysql?
What is mysql community server?
What is mysql connection limit?
Is mysql server free?
Can mysql handle billions of records?
can you tell what are the different set operations available in mysql? : Mysql dba
