sofia403 Posted June 1, 2011 Share Posted June 1, 2011 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, Quote Link to comment https://forums.phpfreaks.com/topic/238124-time-average/ Share on other sites More sharing options...
fenway Posted June 2, 2011 Share Posted June 2, 2011 MySQL can average integers, and that's what times "are". Quote Link to comment https://forums.phpfreaks.com/topic/238124-time-average/#findComment-1224401 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.