Numeric Functions and Operators

TiDB supports all of the numeric functions and operators available in MySQL 5.7.

Arithmetic operators

Name Description
+ Addition operator
- Minus operator
* Multiplication operator
/ Division operator
DIV Integer division
%, MOD Modulo operator
- Change the sign of the argument

Mathematical functions

Name Description
POW() Return the argument raised to the specified power
POWER() Return the argument raised to the specified power
EXP() Raise to the power of
SQRT() Return the square root of the argument
LN() Return the natural logarithm of the argument
LOG() Return the natural logarithm of the first argument
LOG2() Return the base-2 logarithm of the argument
LOG10() Return the base-10 logarithm of the argument
PI() Return the value of pi
TAN() Return the tangent of the argument
COT() Return the cotangent
SIN() Return the sine of the argument
COS() Return the cosine
ATAN() Return the arc tangent
ATAN2(), ATAN() Return the arc tangent of the two arguments
ASIN() Return the arc sine
ACOS() Return the arc cosine
RADIANS() Return argument converted to radians
DEGREES() Convert radians to degrees
MOD() Return the remainder
ABS() Return the absolute value
CEIL() Return the smallest integer value not less than the argument
CEILING() Return the smallest integer value not less than the argument
FLOOR() Return the largest integer value not greater than the argument
ROUND() Round the argument
RAND() Return a random floating-point value
SIGN() Return the sign of the argument
CONV() Convert numbers between different number bases
TRUNCATE() Truncate to specified number of decimal places
CRC32() Compute a cyclic redundancy check value