MySQL :: MySQL 8.0 Reference Manual :: 12.6 Numeric Functions and Operators

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

12.6 Numeric Functions and Operators

12.6.1 Arithmetic Operators
12.6.2 Mathematical Functions

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

PREV HOME UP NEXT