(long tweet) How to get the average of a Date column in MySQL?
Case
You have a column of type Date in MySQL. How to get the average value of this series?
(Don’t think to execute select AVG(myColumnDate)
, it won’t work!)
Fix
Use a query similar to this:
SELECT FROM_UNIXTIME( ROUND( AVG( UNIX_TIMESTAMP( myDateColumn ) ) ) ) FROM `myTable` WHERE 1