Forum Forums Members Recent Posts Forums Oracle Interview Questions... How to get age from... Share: Notifications Clear all How to get age from dob column? Last Post RSS Posts: 27 KV Kumar Admin Topic starter Jul 27, 2020 12:00 pm (@vinodkrsetty) Eminent Member Joined: 4 years ago Hi Please answer this question How to get age from the dob column? Topic Tags agefromdob oracleagefromdate agequeryoracle 1 Reply Posts: 18 VK Jul 27, 2020 1:31 pm (@vinodkrsetty5895) Active Member Joined: 3 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 NameAuthor EmailTitle * Subscribe to this topic Preview 0 Revisions Save Draft Saved Author Name * Author Email * Subscribe to this topic Reply Cancel Preview 0 Revisions Save Draft Saved Share: