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.
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).
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.
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.
In MariaDB, FLOOR() is a built-in numeric function that returns the largest integer value not greater than its argument.
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().
In MariaDB, CEILING() is a built-in numeric function that returns the smallest integer value not less than its argument.
In MariaDB, ATAN2() is a built-in numeric function that returns the arctangent (inverse tangent) of its two arguments.
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.
Continue readingIn MariaDB, UTC_TIMESTAMP() is a built-in date and time function that returns the current UTC date and time.
The result is returned in ‘YYYY-MM-DD HH:MM:SS’ or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is used in a string or numeric context.
UTC stands for Coordinated Universal Time, and is the world standard for regulating time.
Continue reading