mattyt81 Posted September 30, 2011 Share Posted September 30, 2011 Hi I have members DOB stored in a mysql table field called birthday in the following format YYYY-MM-DD I can't seem to convert the time stamp into the members age I need to be able to feed $birthday which is the field in mysql table that is in the above format and then use php code to convert to members age Everything I try doesn't seem to work Quote Link to comment https://forums.phpfreaks.com/topic/248161-how-to-convert-dob-timestamp-from-myql-table-field-to-age-using-php/ Share on other sites More sharing options...
voip03 Posted September 30, 2011 Share Posted September 30, 2011 <?php //calculate years of age (input string: YYYY-MM-DD) function birthday ($birthday){ list($year,$month,$day) = explode("-",$birthday); $year_diff = date("Y") - $year; $month_diff = date("m") - $month; $day_diff = date("d") - $day; if ($day_diff < 0 || $month_diff < 0) $year_diff--; return $year_diff; } echo birthday('1960-06-14'); ?> Quote Link to comment https://forums.phpfreaks.com/topic/248161-how-to-convert-dob-timestamp-from-myql-table-field-to-age-using-php/#findComment-1274336 Share on other sites More sharing options...
ignace Posted September 30, 2011 Share Posted September 30, 2011 You can just do it in MySQL: SELECT floor( (to_days(now()) - to_days(birthday)) / 365.25 ); Create a user-defined function age() in MySQL and you can do this: SELECT age(birthday) AS user_age; Quote Link to comment https://forums.phpfreaks.com/topic/248161-how-to-convert-dob-timestamp-from-myql-table-field-to-age-using-php/#findComment-1274455 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.