generating age

[dewyShaikh]

hello experts...
i have a table employee and in it are attributes like name gender,birthdate...etc..
apart from this i want to automatically generate d employees age from d current date....how can it be done??
thankyou...

[debasisdas]

a simple subtraction of birthdate from sysdate will do the trick for you.

[dzen]

maybe something like this will do the trick

select round(to_number(sysdate-birthdate)/365) age from test_birthdate;

as previously mentioned, sysdate minus birthdate and divided by 365 days in year.