Rounding to the left of the decimal point

January 28, 2011 cruepprich

A little known feature regarding Oracle’s round function is that if you specify a negative integer for the decimal places, Oracle will round the number to the left of the decimal point.

SQL> SELECT ROUND(1234567890,-5) from dual;
ROUND(1234567890,-5)
--------------------
          1234600000
1 row selected.