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
- 7818 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 are all the Common SQL Function?
Is pdo more secure than mysqli?
what is the default port for mysql server? : Mysql dba
How do I download mysql?
What are the 5 r's of managing behaviors?
What is a csv table?
What is mysql server?
Why do we use views instead of tables?
How do I select a database in mysql?
Explain the storage engines in mysql?
How do I start mysql?
What is 1nf 2nf 3nf?
What are the advantages of a procedure?
How to drop an existing table in mysql?
What is the usage of ENUMs in MySQL?
