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
How to get a version of mysql?
Is sql and mysql same?
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
How do I start mysql database?
How to update a root password.
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
How does php communicate with mysql?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
How do I save in mysql?
What is query log in mysql?
What is data in mysql?
How can we run batch mode in mysql?
How do we delete a row in a table?
How do I kill a mysql query?
How to create table with same structure of student table in mysql?