how to calculate age on the fly during a select statement

[aaron4osu]

Is there a way to calculate age on the fly during a select statement based off of a date of birth field?

[aaron4osu]

this is what I have so far:
select name, year(date()-year(dob)) as age
from users;

[r937]

here ya go ===> http://www.sitepoint.com/forums/show...e-based-on-dob