Forum

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

How to get age from dob column?

2 Posts
2 Users
0 Likes
438 Views
KV Kumar
Posts: 27
Admin
Topic starter
(@vinodkrsetty)
Eminent Member
Joined: 3 years ago

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

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

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: