difference in dates

[Joeri Jacobs]

hi,


I have a date-field in a mysql-table and I want to make the difference between this date and the date now.

I've tried this
SELECT `table`.`datefield` - now( ) AS difference FROM table;

The result I get is something crazy. For example:
- difference between now (26/06/2005 21:18) and 24/06/2005 gives me -20050606161211
- difference between now and 16/07/2005 gives me -20050606161119

Not really something usefull I think...

I would like the difference in days, so 24/06/2005 - 26/06/2005 gives me -2 days.

Someone who can help?

Thanks in advance!