Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table temptable (birth_date date);
insert into temptable values(date '1972-04-02');
1 rows affected

insert into temptable values(date '1999-04-23');
1 rows affected

insert into temptable values(date '2001-08-21');
1 rows affected

select trunc(months_between(sysdate,birth_date)/12) year,
           trunc(mod(months_between(sysdate,birth_date),12)) month,
           trunc(sysdate-add_months(birth_date,trunc(months_between(sysdate,birth_date)/12)*12+trunc(mod(months_between(sysdate,birth_date),12)))) day
    from temptable


YEAR
MONTH
DAY


49
2
1

22
1
11

19
9
13