Tuesday, April 18, 2017

YEARS MONTHS DAYS

 SELECT   TRUNC (MONTHS_BETWEEN ('10-JAN-17', '30-JUN-17') / 12)  YEARS,
    MOD (TRUNC (MONTHS_BETWEEN ('10-JAN-17', '30-JUN-17')), 12)  MONTHS,
    TO_DATE ('10-JAN-17')- ADD_MONTHS ( '30-JUN-17',TRUNC (MONTHS_BETWEEN ('10-JAN-17', '30-JUN-17')) ) DAYS
       FROM DUAL;


     YEARS     MONTHS       DAYS
---------- ---------- ----------
         0         -5        -21

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/