How to get age from dob column?
Jul 27, 2020 5:00 am
Hi Please answer this question How to get age from the dob column?
Jul 27, 2020 6:31 am
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.