DATEDIFF in Mysql 4.0

madhumadhi

Dear All,

The following query is not working in Mysql 4.0

Expand|Select|Wrap|Line Numbers

 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

Expand|Select|Wrap|Line Numbers

.

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).

Expand|Select|Wrap|Line Numbers

madhumadhi

Hi,

Thanks a lot.
It's working fine

Best Regards,
Madhumadhi.S

re: DATEDIFF in Mysql 4.0