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

How UTC_TIME() Works in MariaDB

In MariaDB, UTC_TIME() is a built-in date and time function that returns the current UTC time.

The result is returned in ‘HH:MM:SS’ or HHMMSS.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