I have this query:
SELECT timediff(stop_time,start_time) as total from `work`;
which gives me this
where 239 is hours, 53 is minutes and 36 is seconds.
Instead, I want it to 9 days 5 hours, 53 minutes etc
I could either do this from mysql or php, though i would prefer to do it from mysql.
I have mysql version 5.0.11 running on suse sles 9