Dear All,

The following query is not working in Mysql 4.0
[CODE=mysql]SELECT DATEDIFF(
'2007-08-27', '2007-08-17'
) [/CODE]
But this query is working in MySQL 4.1.15.

What should i do to find the date difference in Mysql 4.0 But the date format query is working
ie
[CODE=mysql]SELECT DATE_FORMAT(Dt, '%d-%m-%Y') FROM Product_Master[/CODE].

Kindly provide the solution....