Cool Idea/Question About Demographic Add-ons

[hugo13]

use a sql-statement like

SELECT AVG((YEAR(CURDATE())-YEAR(customers_dob)) - (RIGHT(CURDATE(),5)<RIGHT(customers_dob,5))) AS age 
FROM zen_customers WHERE customers_dob > 0 

OR

SELECT AVG(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(customers_dob)), '%Y')+0) AS age
 FROM zen_customers WHERE customers_dob > 0; 

MYSQL::http://dev.mysql.com/doc/refman/5.0/...culations.html