Birth Date

[Anon]

Hi,

I enter in to database the birth date of a person.
How to get the age while retrieving from data base?
That is I have to subtract the entered birthdate from the present date and get some number
like 23,24,like that.
Any function to use??

Ajay

[Anon]

MySQL solution.

select round((to_days(curdate()) - to_days('1971-05-25'))/365);

That will do the trick for you, Ajay.

Brij.