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
- 7722 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
How will you export tables as an xml file in mysql?
How many groups of data types?
How many rows can a mysql table hold?
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
Is Mysql query is case sensitive?
Why do we use preparedstatement?
Is mysql still popular?
Write a command with which mysql table can be repaired
How to enter numeric values as hex numbers?
How do I kill a mysql query?
What ascii 31?
I want to start and stop mysql on windows? How do I do that?
Can you shard mysql?
Is mysql relational database?
What is the current mysql version?
