Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

Round result from months_between

SQL> 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>