Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Round result from months_between
SQL>
SQL> select round(months_between('17-MAR-61','21-APR-62'))
  2  from dual;
ROUND(MONTHS_BETWEEN('17-MAR-61','21-APR-62'))
----------------------------------------------
                                           -13
1 row selected.
SQL>