In MariaDB, ADD_MONTHS() is a built-in date and time function that adds a given number of months to a date, and returns the result.
The date can be a date, datetime, or timestamp value.
This function was introduced in MariaDB 10.6.1 to enhance Oracle compatibility. There are at least 6 other ways to add months to a date in MariaDB.
Continue readingIn MariaDB, PI() is a built-in function that returns the value of the number π (pi).
The number Ï€ is a mathematical constant. It is defined as the ratio of a circle’s circumference to its diameter, and it also has various equivalent definitions. It is approximately equal to 3.141593, although its decimal representation never ends.
Continue readingIn MariaDB, CRC32() is a built-in numeric function that computes a cyclic redundancy check value and returns a 32-bit unsigned value.
CRC32 is a popular checksum algorithm used to detect data corruption.
Continue readingIn MariaDB, LOG10() is a built-in function that returns the base-10 logarithm of its argument.
In MariaDB, LOG2() is a built-in function that returns the base-2 logarithm of its argument.
In MariaDB, TRUNCATE() is a built-in numeric function that returns a given number, truncated to a given number of decimal places.
In MariaDB, DIV performs integer division.
It discards from the division result any fractional part to the right of the decimal point.
Continue readingIn MariaDB, ABS() is a built-in numeric function that returns the absolute (non-negative) value of its argument.
In MariaDB, ROUND() is a built-in numeric function that rounds its argument to a given number of decimal places.
In MariaDB, ASIN() is a built-in numeric function that returns the arcsine (inverse sine) of its argument.
In other words, it returns the value whose sine is the argument.
Continue reading