numeric functions

In MariaDB, LOG() is a built-in function that returns the natural logarithm of its argument to a given base.

It can be called with one or two arguments:

• 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.

When called with a single argument, LOG() is the inverse of EXP(), and it’s the same as using LN().

Read more

In MariaDB, LN() is a built-in function that returns the natural logarithm of its argument. In other words, it returns the base-e logarithm of its argument.

The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.

LN() is the inverse of EXP(), and it’s the same as using LOG() with the single argument syntax.

Read more

In MariaDB, EXP() is a built-in function that returns the value of e (the base of natural logarithms) raised to the power of the argument.

The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.

The inverse of EXP() is the LN() function or LOG() function (when using the single argument syntax).

Read more

In MariaDB, RADIANS() is a built-in function that returns its argument converted from degrees to radians.

The RADIANS() function is the converse of the DEGREES() function.

Read more

In MariaDB, DEGREES() is a built-in function that returns its argument converted from radians to degrees.

The DEGREES() function is the converse of the RADIANS() function.

Read more

In MariaDB, FLOOR() is a built-in numeric function that returns the largest integer value not greater than its argument.

Read more

In MariaDB, CEIL() is a built-in numeric function that returns the smallest integer value not less than its argument.

CEIL() is a synonym for CEILING().

Read more

In MariaDB, CEILING() is a built-in numeric function that returns the smallest integer value not less than its argument.

Read more

In MariaDB, ATAN2() is a built-in numeric function that returns the arctangent (inverse tangent) of its two arguments.

Read more

In MariaDB, ATAN() is a built-in numeric function that returns the arctangent (inverse tangent) of its argument.

In other words, it returns the value whose tangent is the argument.

Read more