MySQL 5.5 Reference Manual  /  Functions and Operators  /  Numeric Functions and Operators

## 12.6 Numeric Functions and Operators

Table 12.10 Numeric Functions and Operators

Name Description
`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
`DIV` Integer division
`/` Division operator
`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
`LOG2()` Return the base-2 logarithm of the argument
`-` Minus operator
`MOD()` Return the remainder
`%`, `MOD` Modulo operator
`PI()` Return the value of pi
`+` Addition operator
`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
`*` Multiplication operator
`TRUNCATE()` Truncate to specified number of decimal places
`-` Change the sign of the argument