SELECT ename, hiredate, SYSDATE,

ROUND (MONTHS_BETWEEN (SYSDATE, hiredate)) "Monate zwischen"

FROM emp;

ENAME HIREDATE SYSDATE MONATE_ZWISCHEN

SMITH 17-DEC-80 17-FEB-93 146

ADAMS 26-DEC-92 17-FEB-93 2

.............................................