Important
You are viewing the documentation of an older version of the TiDB database (TiDB v5.4). It is recommended that you use the latest LTS version of the TiDB database.
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 |