How LN() Works in MariaDB

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

How EXP() Works in MariaDB

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

How UTC_TIMESTAMP() Works in MariaDB

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

Read more