Hi Guys,

I have the following MySQL query and I would like to find the time difference in days, mins, hours between the current time and the "end_date" field (which is a datetime filed).

PHP Code:
select auctions.end_date,domains.* from domains left join auctions on auctions.domain_id domains.id where end_date now() and active='1' order by end_date desc limit 10 
Any ideas how this can be achieved in the above query?

Thanks