# Numeric Functions and Operators

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

## Arithmetic operators

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

## Mathematical functions

NameDescription
`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