Say I have a string
Code: Select all
$dob = "1988-10-10";Thanks.
Moderator: General Moderators
Code: Select all
$dob = "1988-10-10";Code: Select all
$year = (int)substr($dob,0,4); //takes the year out
$thisYear = date(Y);
$age = $thisYear - $year;Code: Select all
SELECT ....
YEAR(NOW()) -
YEAR(dob) -
(DATE_FORMAT(NOW(), '%m%d') < DATE_FORMAT(dob, '%m%d'))
AS age
FROM...