Forum

How to get age from...
 
Share:
Notifications
Clear all

How to get age from dob column?


Posts: 27
Admin
Topic starter
(@vinodkrsetty)
Eminent Member
Joined: 5 years ago

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

1 Reply
Posts: 18
 VK
(@vinodkrsetty5895)
Active Member
Joined: 4 years 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

Self Learning Video Tutorials - Software Course

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: