MariaDB Numeric Functions (Full List)

This article contains a full list of built-in MariaDB numeric functions and operators.

The following is a list of numeric functions and operators available in MariaDB. Click on each function or operator name to see an explanation of the function, its syntax, and examples.

NameDescription
ABS()Returns the absolute value of its argument.
ACOS()Returns the arc cosine of its argument.
ASIN()Returns the arc sine of its argument.
ATAN()When called with one argument, returns the arc tangent of that argument.

When called with two arguments returns the arc tangent of its two arguments (same as the ATAN2() function).
ATAN2()Returns the arc tangent of its two arguments.
CEIL()Returns the smallest integer value not less than its argument. Synonym for CEILING().
CEILING()Returns the smallest integer value not less than its argument.
CONV()Converts numbers between different number bases.
COS()Returns the cosine of its argument.
COT()Returns the cotangent of its argument.
CRC32()Computes a cyclic redundancy check value.
DEGREES()Converts radians to degrees.
DIVInteger division.
EXP()Returns the value of e (the base of natural logarithms) raised to the power of its argument.
FLOOR()Returns the largest integer value not greater than its argument.
LN()Returns the natural logarithm of its argument.
LOG()Returns the natural logarithm of its first argument.
LOG10()When called with one argument, returns the natural logarithm of the argument.

When called with two arguments, returns the logarithm of the second argument to the base specified in the first argument.
LOG2()Returns the base-2 logarithm of its argument.
MOD()Returns the remainder of the first argument divided by the second.
OCT()Returns a string representation of the octal value of its argument.
PI()Returns the value of pi (π).
POW()Returns the argument raised to the specified power.
POWER()Returns the argument raised to the specified power. Synonym for POW().
RADIANS()Returns its argument converted from degrees to radians.
RAND()Returns a random floating-point value.
ROUND()Rounds the argument to a given decimal place.
SIGN()Returns the sign of its argument.
SIN()Returns the sine of its argument.
SQRT()Returns the square root of its argument.
TAN()Returns the tangent of its argument.
TRUNCATE()Truncates to specified number of decimal places.