Calculating Age

[karatekid36]

I have some birthdates in a table in the YYYY-MM-DD format and I was curious what the best way is to calculate a person's age so that it could in turn be displayed in a web page?

[paul2463]

$now = date("Y");  //year of now
$query = "SELECT DATE_FORMAT(date_column,'%Y') AS birthdate FROM table";
$result = mysql_query($query) or die ("cannot get dates" . mysql_error());
$row = mysql_fetch_assoc($result);
$bdate = $row['birthdate']; //year the person was born

$age = $now - $bdate; //now - year of birth

 

will work for part of the year but needs some maths modfications to make it work for the rest of the year because if i was born in september 1966 I am 40 but because the above will use 2007 and 1966 I will be 41

 

[Wildbug]

SELECT YEAR(NOW()) - YEAR(birthdate) - (MONTH(birthdate) < MONTH(NOW()) OR DAYOFMONTH(birthdate) < DAYOFMONTH(NOW())) AS Age FROM tbl;

[fenway]

There's a TO_DAYS() function that you can easily use to get days old.