create table D (
EMPNO varchar(4) not null,
ENAME varchar(10) not null,
HIREDATE DATE not null
);

insert into D (EMPNO,ENAME,HIREDATE) values ('7369','AAA',TO_DATE('1980-12-17','YYYY-MM-DD'));
insert into D (EMPNO,ENAME,HIREDATE) values ('7649','BBB',TO_DATE('1981-09-23','YYYY-MM-DD'));
commit;

/*날짜사이 년,월,일로 계산하기*/

SELECT empno
     , ename
     , hiredate
     , TRUNC (mb / 12) || '년' year#
     ,    TRUNC (MONTHS_BETWEEN (SYSDATE
                               , ADD_MONTHS (hiredate, 12 * TRUNC (mb / 12))
                                )
                )
       || '개월' month#
     , TRUNC (SYSDATE - ADD_MONTHS (hiredate, TRUNC (mb))) || '일' day#
  FROM (SELECT empno
             , ename
             , hiredate
             , MONTHS_BETWEEN (SYSDATE, hiredate) mb
          FROM D);

이렇게 오라클에선 표현을 할 수있는데

DB2에선 어떻게 할수 있나요..아무리 애를 써봐도 DB2초보자에겐 한계가 있네요..