Forum

How to get age from...
 
Notifications
Clear all

How to get age from dob column?


KV Kumar
Posts: 27
Admin
Topic starter
(@vinodkrsetty)
Member
Joined: 2 years ago

Hi Please answer this question How to get age from the dob column?

1 Reply
VK
Posts: 17
 VK
(@vinodkrsetty5895)
Active Member
Joined: 1 year ago

SELECT
TRUNC((SYSDATE - TO_DATE(DOB, 'YYYY-MM-DD'))/ 365.25) AS AGE_ASOFTODAY FROM DUAL;

It is one of the easiest way to write a query to achieve this requirement. 

Reply
Share: