SELECT ENAME, MONTHS_BETWEEN(SYSDATE,HIREDATE)
FROM EMP;
ENAME | MONTHS_BETWEEN(SYSDATE,HIREDATE)
KING | 450.4266
BLAKE | 456.94281
CLARK | 456.684
SCOTT | 437.265
SELECT TO_DATE('2019-06-01','RRRR-MM-DD') - TO_DATE('2018-10-01','RRRR-MM-DD')
FROM DUAL
TO_DATE('2019-06-01','RRRR-MM-DD') - TO_DATE('2018-10-01','RRRR-MM-DD')
243
SELECT T(O_DATE('2019-06-01','RRRR-MM-DD') - TO_DATE('2018-10-01','RRRR-MM-DD') / 7) AS "총 주수"
FROM DUAL
총 주수
35