oracle - trunc and round function in sql - Stack Overflow

Is trunc and round the same with negative arguments? SQL> select round(123456.76,-4) from dual; ROUND(123456.76,-4) ----- 120000 SQL> ... No, behavior depends on the value of the significant digit (the 3rd digit (the 3) is the significant one in your case

stackoverflow.com