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