time average

[sofia403]

MySQL version 5.0.81

 

I have a time thats being caculated on the fly like so

 

DATEDIFF(NOW(), Date) as TotalTime
$Date_ts = strtotime($row['Date']);
$Date_str = date("M-d-Y", $Date_ts);
$TotalTime = floor((time() - $Date_ts)/(60*60*24)) . ' days';

and i was wondering if its possible to calculate average of this values, and it also would have to be done only on selected records.

 

thanks, 

[fenway]

MySQL can average integers, and that's what times "are".