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

How to create table show example

0 Answers  

---

What is MySQL Stored Procedure?

1 Answers  

---

What is dirty read and phantom read?

0 Answers  

---

How to get current MySQL version?

0 Answers  

---

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

2 Answers  

---

what is the difrence between sql and pl/sql

21 Answers   Wipro,

---

What are the steps required to view your mysql database?

0 Answers  

---

What is mysql slow query?

0 Answers  

---

In how many ways we can retrieve data in the result set of mysql using php?

0 Answers  

---

How to use mysqldump to create a copy of the database?

0 Answers  

---

What is the datatype for password in mysql?

0 Answers  

---

What is delimiter $$?

0 Answers  

---