2.数字函数
round,trunc,mod
round(参数1,参数2):四舍五入
参数1:表示要进行四舍五入操作的数字
参数2:表示保留到的位数
若不写参数2,则表示对整数部分进行四舍五入,即参数2为0的时候
注意:负数代表小数点之前,0,正数代表小数点之后
select round(1234.567) from dual;
select round(1234.567,0) from dual;
结果:1235
select round(1234.567,1) from dual;
结果:1234.6
select round(1234.567,2) from dual;
结果:1234.57
select round(1234.567,3) from dual;
结果:1234.567
select round(1234.567,-1) from dual;
结果:1230
select round(1234.567,-2) from dual;
结果:1200
select round(1234.567,-3) from dual;
结果:1000
若参数2为正数,则看参数2后一位,满5则向前进一位,其后置为0,反之。
若参数2为负数,则参数2满5,向前进一位,参数2及其后置为0,反之。
select round(1534.567,-3) from dual;
结果:2000
trunc(参数1,参数2):截取函数
其用法与round函数用法一样,但trunc函数只舍去,不进位
select trunc(1234.567) from dual;
结果:1234
select trunc(1234.567,0) from dual;
结果:1234
select trunc(1234.567,1) from dual;
结果:1234.5
select trunc(1234.567,2) from dual;
结果:1234.56
select trunc(1234.567,3) from dual;
结果:1234.567
select trunc(1534.567,3) from dual;
结果:1534.567
select trunc(1234.567,-1) from dual;
结果:1230
select trunc(1234.567,-2) from dual;
结果:1200
select trunc(1234.567,-3) from dual;
结果:1000
select trunc(1534.567,-3) from dual;
结果:1000
注意:当参数2为正数时,截取到该位,其后置为0
当参数2为负数时,截取到该位,参数2及其后均置为0。
mod(参数1,参数2):取余函数,返回两数相除的余数
select mod(12,2) from dual;
结果:0
select mod(28,15) from dual;
结果:13
select mod(15,0) from dual;
结果:15
若参数为0,则返回参数1