Jonathan Lalou's Blog

(long tweet) How to get the average of a Date column in MySQL?

Author: Jonathan Lalou | November 13, 2012

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!)

Use a query similar to this:

[sql]SELECT FROM_UNIXTIME( ROUND( AVG( UNIX_TIMESTAMP( myDateColumn ) ) ) )

FROM `myTable`

WHERE 1[/sql]

Posted in en-US, long tweets | Tags: MySQL