Skip to toolbar

Forum

How to get age from...
 
Notifications
Clear all

How to get age from dob column?  


vinodkrsetty
Posts: 15
Admin
(@vinodkrsetty)
Member
Joined: 1 year ago

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

1 Reply
VK
Posts: 17
 VK
(@vinodkrsetty5895)
Active Member
Joined: 2 months 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

Leave a reply

Author Name

Author Email

Title *

Maximum allowed file size is 10MB

 
Preview 0 Revisions Saved
Share: