round(double a) 返回对a四舍五入的bigint值
round(double a,int d) 返回四舍五入值,保留d位小数
bround(double a) 银行家舍入法(1-4舍,6-9进,5:前位数是偶,舍,前位数是奇,进)
bround(double a,int d) 银行家舍入法,保留d位小数
floor(double a) 向下取整 (取左值)
ceil(double a),ceiling(double a)向上取整(取右值)
rand()/rand(int seed) 返回一个(0-1)之间的随机数,若给定种子,这返回一个稳定的随机数序列(伪随机)
exp(double a)/exp(decimal a) 返回e的a次幂
pow(double a,double p), power(double a,double p)) 计算a的p次幂
ln(double a)/ln(decimal a) 以自然数为底a的对数
log10(double a)/log10(decimal a) 以10为底a的对数
log2(double a)/log2(decimal a) 以2为底a的对数
log(double base,double a)log(DECIMAL base,DECIMAL a) 以base为底a的对数
sqrt(DOUBLE a),sqrt(DECIMAL a) 计算a的平方根
bin(bigint a)二进制a的string类型
hex(bigint a)十六进制a的string类型,若a为string类型,转换为字符对应的十六进制
unhex(string a)逆十六进制
conv(bigint/string num,int from_base,int to_base) 将num从from_base进制转换为to_base进制
abs(double a) 计算a的绝对值
pmod(int/double a,int/double b) a%b
sin(double/decimal a) sin a
asin(double/decimal a) arcsin a
cos(double/decimal a) cos a
acos(double/decimal a) arccos a
tan(double/decimal a) tan a
atan(double/decimal a) arctan a
degrees(double/decimal a) 弧度-->角度
radians(double/decimal a) 角度-->弧度
positive(int/double a) 返回a
negative(int/double a) 返回-a
sign(double/decimal a) a为正: