DATEDIFF in Mysql 4.0

[madhumadhi]

Dear All,

The following query is not working in Mysql 4.0

SELECT DATEDIFF(
'2007-08-27', '2007-08-17'
) 

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

SELECT DATE_FORMAT(Dt,'%d-%m-%Y') FROM Product_Master

.

Kindly provide the solution.

Thanks in advance.

Best Regards,
Madhumadhi.S

[mwasif]

Kindly use appropriate CODE tags when posting code.


Use can use TO_DAYS(). It returns a day number (the number of days since year 0).

SELECT TO_DAYS('2007-08-27') - TO_DAYS('2007-08-17')

[madhumadhi]

Hi,

Thanks a lot.
It's working fine

Best Regards,
Madhumadhi.S