All Numeric Functions In MariaDB

The following table is a complete list of date and time functions available in MariaDB.

Function	Description
`ABS()`	Returns the absolute value of its argument.
`ACOS()`	Returns the arccosine of its argument.
`ASIN()`	Returns the sine arc of its argument.
`ATAN()`	When called with one argument, returns the arctangent of that argument. When called with two arguments, returns the arctangent of its two arguments (same as the `ATAN2()` function ).
`ATAN2()`	Returns the arctangent 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()`	Convert numbers between different number bases.
`COS()`	Returns the cosine of its argument.
`COT()`	Returns the cotangent of its argument.
`CRC32()`	Computes the cyclic redundancy check value.
`DEGREES()`	Convert radians to degrees.
`DIV`	Integer division.
`EXP()`	Returns the value of e (the base of the natural logarithm) 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 dividing the first argument by the second argument.
`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 the argument converted from degrees to radians.
`RAND()`	Returns a random floating point value.
`ROUND()`	Rounds the argument to the given number of decimal places.
`SIGN()`	Returns the symbol 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 the specified number of decimal places.

On this page