Help: Converting Date to Age

[Rottingham]

Hello All!

 

I know you can use an mySQL query to convert a date value to an Age, but I'm trying to figure out how to do it in PHP.

 

If I have a date, 1978-02-03, what would I use to convert that into an age? It should = 29.

 

Thanks for any advice! It is 2am and I'm sleepy!

[hvle]

SELECT (YEAR(CURDATE())-YEAR('1978-02-03'))-(RIGHT(CURDATE(),5)<RIGHT('1978-02-03',5)) as age;

if you have a column birthdate in table t, use like this:

SELECT (YEAR(CURDATE())-YEAR(birthdate))-(RIGHT(CURDATE(),5)<RIGHT(birthdate,5)) from t  as age;

[Rottingham]

Thank you for the help on this. I'm sorry I didn't communicate very well! Like I said, it was 2am.

 

I am looking to see how it is done outside of the query. I.e I have already pulled the data, and at some point later I want to take $DOB and do something like get_age($DOB);

[hvle]

Actually, I am the one who doesn't read well.

it is similar:

<?php
$birth = '1975-02-05';
$now = date('Y-m-d'); // get today's year and date

$age = substr($now, 0, 4) - substr($birth, 0, 4);
if (substr($birth,-5) > substr($now,-5)) // if birthdate later than today's date
    $age -= 1;

echo $age;
?>