Db2 11.1

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

create table my_table (
  date_integer INT
  )
insert into my_table (date_integer) values (20030530), (19760117);
SELECT 
    TO_DATE(date_integer, 'YYYYMMDD')
  , age( TO_DATE(date_integer, 'YYYYMMDD') )  / 10000 age_in_years
from my_table


1
AGE_IN_YEARS


2003-05-30 00:00:00.000000
20

1976-01-17 00:00:00.000000
47


select
   date(TO_DATE(date_integer, 'YYYYMMDD'))   as my_dt
 , (d.age_yymmdd / 10000)                    as age_years
 , int(left(right(d.age_yymmdd,4),2))        as age_months
 , int(right(d.age_yymmdd,2))                as age_days
, (d.age_yymmdd / 10000) 
  || ':' || left(right(d.age_yymmdd,4),2)
  || ':' || right(d.age_yymmdd,2)            as age_ymd
 , d.age_yymmdd
from my_table t
join table  (
  select age( date(TO_DATE(t.date_integer, 'YYYYMMDD')) ) age_yymmdd
  from my_table
  ) as d on true


MY_DT
AGE_YEARS
AGE_MONTHS
AGE_DAYS
AGE_YMD
AGE_YYMMDD


2003-05-30
20
0
2
20:00:02
200002

1976-01-17
47
4
15
47:04:15
470415

2003-05-30
20
0
2
20:00:02
200002

1976-01-17
47
4
15
47:04:15
470415

MY_DT	AGE_YEARS	AGE_MONTHS	AGE_DAYS	AGE_YMD	AGE_YYMMDD
2003-05-30	20	0	2	20:00:02	200002
1976-01-17	47	4	15	47:04:15	470415
2003-05-30	20	0	2	20:00:02	200002
1976-01-17	47	4	15	47:04:15	470415