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

In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

0 Answers  

---

Is mysql a programming language?

0 Answers  

---

How can we change the name of a column of a table?

7 Answers  

---

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?

0 Answers  

---

How can I see connections in mysql?

0 Answers  

---

Write a command to list all databases in mysql?

0 Answers  

---

What is check constraint?

3 Answers  

---

Why do we use mysql?

0 Answers  

---

What is sql in mysql?

0 Answers  

---

explain GROUPBY & HAVING clause with examples.

0 Answers  

---

Explain the difference between mysql and mysqli interfaces in PHP?

10 Answers   TCS,

---

How many rows can be inserted in mysql at a time?

0 Answers  

---