Results 1 to 7 of 7
Dec 10, 2008, 07:37 #1
Find time difference between two dates
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).
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