What is query to find-out age using birthdate?

[roodiii]

Hi All,

I have to write the query in the SQL which will find the age of the person when we provide only birth date.

If anybody knows the query to find out the age using birth date then please let me know.

Your help will be greatly appreciated..

[Praetor]

HI friend ,

I have a query which can find-out the age of using birth date which is as follows:

SELECT (SYSDATE-BIRTH_DATE)/365 "YEAR"
FROM nameOFtable

Please try this and let me know.

[Katty]

Hi,

Please try to execute below query:

SELECT TRUNCATE(monthsBetween (Date_of_birth,sysdate)/12(Total month of the year))

FROM

ageTable;

[Reegan]

Below query is running successfully on my system. Please copy below query and try to run on your system:

select trunc((number(to_char(systemdate,'YYYYMMDD'))
number(char(date '2009-10-24','YYYYMMDD'))
)/10000)
AS Person_age

from personTable