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
- 7584 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 to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
How can we get the number of rows affected by query?
Is mysql free software?
Is mysql distributed?
write a command to view the content of the table
Why phpmyadmin is used for mysql?
what is cte? : Mysql dba
How do I kill a mysql query?
What is a query in mysql?
How do I view a mysql database?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
What is truncate in mysql?
What are the advantages/disadvantages of mysql and php?
What is key in mysql?
How do I view tables in mysql workbench?
