MariaDB Math Functions

In MariaDB, ABS() is a built-in numeric function that returns the absolute value of a given number.

In MariaDB, ACOS() is a built-in numeric function that returns the arccosine of a given number.

In MariaDB, ASIN() is a built-in numeric function that returns the arcsine of a given number.

In MariaDB, ATAN() is a built-in numeric function that returns the arctangent of a given number.

In MariaDB, ATAN2() is a built-in numeric function that returns the arctangent of a given number.

In MariaDB, CEIL() is a built-in numeric function that returns the smallest integer value greater than or equal to a specified number.

In MariaDB, CEILING() is a built-in numeric function that returns the smallest integer value greater than or equal to a specified number.

In MariaDB, it CONV() is a built-in numeric function that converts a number from one base to another, such as from base 10 to base 2.

In MariaDB, COS() is a built-in numeric function that returns the cosine of a given radian.

In MariaDB, COT() is a built-in numeric function that returns the cotangent of a given number.

In MariaDB, CRC32() is a built-in numeric function that computes a cyclic redundancy check value and returns a 32-bit unsigned value.

In MariaDB, CRC32C() is a built-in numeric function that computes a cyclic redundancy check value and returns a 32-bit unsigned value.

In MariaDB, DEGREES() is a built-in function that converts a given radian value to degrees and return the result.

In MariaDB, EXP() is a built-in function that returns e raised to the power of the given number.

In MariaDB, FLOOR() is a built-in number function that returns the largest integer value less than or equal to a given number.

In MariaDB, LN() is a built-in function that returns the natural logarithm of a given value.

In MariaDB, LOG() is a built-in function that returns the logarithm of a specified number to a specified base.

In MariaDB, LOG10() is a built-in function that returns the base 10 logarithm of the given parameter.

In MariaDB, LOG2() is a built-in function that returns the base-2 logarithm of a given value.

In MariaDB, MOD() is a built-in function that performs a modulo operation on two given numeric arguments and returns the result.

The MariaDB OCT() function returns the string representation of the octal value of the given number.

The MariaDB PI() function returns the value of π (pi) with 6 decimal places.

In MariaDB, POW(x, y) is a built-in function that returns x raised to the power of y.

In MariaDB, POWER(x, y) is a built-in function that returns x raised to the power of y.

In MariaDB, RADIANS() is a built-in function that returns a given degree value converted to radians.

In MariaDB, RAND() is a built-in function that returns a random number between 0 (inclusive) and 1 (exclusive).

In MariaDB, ROUND() is a built-in numeric function that rounds a given numeric parameter to a given decimal places.

In MariaDB, SIGN() is a built-in function that returns -1, 0, or 1 to indicate whether the given number is negative, zero, or positive.

In MariaDB, SIN() is a built-in numeric function that returns the sine of a given value in radians.

In MariaDB, SQRT() is a built-in numeric function that returns the square root of a given number.

In MariaDB, TAN() is a built-in numeric function that returns the tangent of a specified number.

In MariaDB, TRUNCATE() is a built-in numeric function that truncates a given number to a given decimal places.