By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT TRUNC(SUM(year*365 + month*31 + day)/365) AS years,
TRUNC(MOD(SUM(month*31 + day), 365)/31) AS month,
MOD(MOD(SUM(month*31 + day), 365), 31) AS day
FROM
(
Select 1 as year, 5 as month, 10 as day from dual
union all
Select 1 as year, 13 as month, 25 as day from dual
) t1;
| YEARS | MONTH | DAY |
|---|---|---|
| 3 | 7 | 11 |
SELECT TRUNC(SUM(year + month/12 + day/365)) AS years,
TRUNC(MOD(SUM(month + day/31), 12)) month,
MOD(SUM(day) , 31) day
FROM
(
Select 1 as year, 5 as month, 10 as day from dual
union all
Select 1 as year, 13 as month, 25 as day from dual
) t1;
| YEARS | MONTH | DAY |
|---|---|---|
| 3 | 7 | 4 |