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 |