oracle - trunc and round function in sql - Stack Overflow

oracle - trunc and round function in sql - Stack Overflow

瀏覽:867
日期:2025-04-27
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...看更多