FIND YEARS MONTHS DAYS FROM DATE OF BIRTH IN ORACLE SQL

FIND YEARS MONTHS DAYS FROM DATE OF BIRTH IN ORACLE SQL

SELECT /+ parallel(32)/ SYSDATE, ci.DAT_BIRTH_CUST,

trunc(months_between(sysdate,ci.DAT_BIRTH_CUST) / 12) as years, 

trunc(months_between(sysdate,ci.DAT_BIRTH_CUST) - (trunc(months_between(sysdate,ci.DAT_BIRTH_CUST) / 12) * 12)) as months,

trunc(sysdate) - add_months(ci.DAT_BIRTH_CUST, trunc(months_between(sysdate,ci.DAT_BIRTH_CUST))) as days

FROM CUSTOMER ci

OUTPUT:-

Note:-  /+ parallel(32)/ use to execute faster output