12.6 Numeric Functions and Operators数值函数和运算符

12.6.1 Arithmetic Operators算术运算符
12.6.2 Mathematical Functions数学函数

Table 12.8 Numeric Functions and Operators数值函数和运算符

Name名称Description描述
%, MODModulo operator求模运算符
*Multiplication operator乘法运算符
+Addition operator加法运算符
-Minus operator减法运算符
-Change the sign of the argument改变参数的符号
/Division operator除法运算符
ABS()Return the absolute value返回绝对值
ACOS()Return the arc cosine返回弧余弦
ASIN()Return the arc sine返回弧正弦
ATAN()Return the arc tangent返回反正切
ATAN2(), ATAN()Return the arc tangent of the two arguments返回两个参数的反正切值
CEIL()Return the smallest integer value not less than the argument返回不小于参数的最小整数值
CEILING()Return the smallest integer value not less than the argument返回不小于参数的最小整数值
CONV()Convert numbers between different number bases在不同的基数之间转换数字
COS()Return the cosine返回余弦
COT()Return the cotangent返回余切
CRC32()Compute a cyclic redundancy check value计算循环冗余校验值
DEGREES()Convert radians to degrees将弧度转换为度
DIVInteger division整除
EXP()Raise to the power of求自然对数的底数的乘方
FLOOR()Return the largest integer value not greater than the argument返回不大于参数的最大整数值
LN()Return the natural logarithm of the argument返回参数的自然对数
LOG()Return the natural logarithm of the first argument返回第一个参数的自然对数
LOG10()Return the base-10 logarithm of the argument返回参数的以10为底的对数
LOG2()Return the base-2 logarithm of the argument返回参数的以2为底的对数
MOD()Return the remainder返回余数
PI()Return the value of pi返回圆周率的值
POW()Return the argument raised to the specified power返回参数的指定次方的幂
POWER()Return the argument raised to the specified power返回参数的指定次方的幂
RADIANS()Return argument converted to radians返回参数转换为弧度的值
RAND()Return a random floating-point value返回随机浮点值
ROUND()Round the argument将参数四舍五入
SIGN()Return the sign of the argument返回参数的符号
SIN()Return the sine of the argument返回参数的正弦值
SQRT()Return the square root of the argument返回参数的平方根
TAN()Return the tangent of the argument返回参数的正切值
TRUNCATE()Truncate to specified number of decimal places截断到指定的小数位数

12.6.1 Arithmetic Operators
12.6.2 Mathematical Functions