Is there a way to calculate age on the fly during a select statement based off of a date of birth field?
this is what I have so far:select name, year(date()-year(dob)) as agefrom users;
here ya go ===> http://www.sitepoint.com/forums/showthread.php?358038-Selecting-people-with-a-certain-age-range-based-on-dob
This topic is now archived. It is frozen and cannot be changed in any way.