Answer / sergii

DATEDIFF(expr1,expr2)

DATEDIFF() returns expr1 – expr2 expressed as a value in
days from one date to the other. expr1 and expr2 are date
or date-and-time expressions. Only the date parts of the
values are used in the calculation.

mysql> SELECT DATEDIFF('1997-12-31 23:59:59','1997-12-30');
-> 1
mysql> SELECT DATEDIFF('1997-11-30 23:59:59','1997-12-31');
-> -31

Answer / 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';

I want to start and stop mysql on windows? How do I do that?

0 Answers  

---

What is Foreign Key? What is the main difference between primary key and Foreign Key ? How Foreign Key can be defined? Is Foreign key is used to join two or more table?

4 Answers  

---

What are the benefits of mysql?

0 Answers  

---

Can't connect mysql server on localhost?

0 Answers  

---

Is mysql still popular?

0 Answers  

---

How do I find mysql version in mysql workbench?

0 Answers  

---

What is memory table in mysql?

0 Answers  

---

What is a definer?

0 Answers  

---

What is unsigned int in mysql?

0 Answers  

---

What is memory table?

0 Answers  

---

How do I find the database name in mysql?

0 Answers  

---

Can we use mysql and mysqli together?

0 Answers  

---