Gbase8s 数据库标量函数包括数学函数、字符串函数、日期时间函数。以下是对Gbase8s标量函数中数学函数的介绍:
1、abs 返回绝对值
示例:
select abs(-7.6) as num1, abs(7.6) as num2 from dual;
结果:
2、ceil 返回大于参数的数值
示例:
select ceil(4.6) as f_ceil from dual;
结果:
3、floor 返回小于参数的数值
示例:
select floor(4.6) as f_floor from dual;
结果:
4、round 返回参数的四舍五入数值
示例:
select round(4.6) as f_round from dual;
结果:
5、mod 返回第一个参数的模
示例:
select mod(10, 3) as f_mod from dual;
结果:
6、pow 计算数值的N次方,sqrt 计算平方根,root 计算数值的N次方根
示例:
select pow(2, 3) as f_pow3, sqrt(25) as f_sqrt, root(64, 3) as f_root from dual;
结果: