mysql date function query

i have two date value in database, planned_end_date and actual_end_date , i.e suppose i planned that work will over 2006-03-20 but its actula end date is 2006-04-25. i have to caluculate the days difference between this. That value i have to display in report form. any mysql query for this, any suggesion please.

Thanks
akshaya

From the MySQL manual:

DATEDIFF(expr,expr2)

DATEDIFF() returns the number of days between the start date expr and the end date expr2. expr 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

DATEDIFF() was added in MySQL 4.1.1.