Tuesday, January 23, 2018

ORACLE - How round number to three decimal places

select ( 3.652 * 5.673 ) as n1, round( 3.652 * 5.673, 3 ) as n2 from dual
Output:
        N1         N2
---------- ----------
20,717796  20,718  

No comments:

Post a Comment