Round result from months_between : ROUND « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. ROUND
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>








13.15.ROUND
13.15.1.The ROUND Function
13.15.2.Datetime Formatting Parameters for ROUND(x[, unit])
13.15.3.ROUND(x[, unit]) : round x. By default, x is rounded to the beginning of the nearest day
13.15.4.Round date to day
13.15.5.Rounds May 25, 2005, to the first day in the nearest month
13.15.6.Rounding to the Nearest Minute
13.15.7.ROUND(date_in_1,'CC')
13.15.8.Round result from months_between