trying to calculate age

[mastereh]

I have a table which stores the Date of birth for various policy holders.

I am trying to create a report that summarizes how many clients are of a particular age.

 

Ie
Number of policy holders under 25 |     Number of policy holders 25 and over

5000                                                       |                               4000          

 

Does anyone know how I can write my sql to have today's date - the DOB field = age?

Thanks.

[augarte]

HI,

You can use the following query: 

select convert(int, DATEDIFF (DAY, BornDat, GETDATE()) / 365.25) from People

This will return and integer variable with the age of each row in your table. 

Hope this helps,

Regards.

 

[federico.cattozzi]

 Oracle:

Code:

SELECT (SELECT COUNT (*)          FROM holder         WHERE TRUNC (MONTHS_BETWEEN (SYSDATE, born_date) / 12) < 25)          AS under_25,       (SELECT COUNT (*)          FROM holder         WHERE TRUNC (MONTHS_BETWEEN (SYSDATE, born_date) / 12) >= 25)          AS equal_25_and_over  FROM DUAL