In MariaDB, TO_CHAR() is a built-in string function that converts a date/time expression to a string.
The expression can be a date, datetime, time, or timestamp value.
This function was introduced in MariaDB 10.6.1 to enhance Oracle compatibility.
Continue readingIn MariaDB, SIGN() is a built-in function that returns the sign of its argument as -1, 0, or 1, depending on whether the argument is negative, zero, or positive.
In MariaDB, SIN() is a built-in numeric function that returns the sine of its argument, where its argument is provided in radians.
In MariaDB, SYS_GUID() is a built-in function that returns a 16-byte globally unique identifier (GUID).
This function was introduced in MariaDB 10.6.1 to enhance Oracle compatibility.
Continue readingIn MariaDB, UUID_SHORT() is a built-in function that returns a short Universal Unique Identifier (UUID).
It returns a 64-bit unsigned integer (as opposed to the string-form 128-bit identifier as returned by the UUID() function).
In MariaDB, UUID() is a built-in function that returns a Universal Unique Identifier (UUID).
The UUID is generated according to “DCE 1.1: Remote Procedure Call” (Appendix A) CAE (Common Applications Environment) Specifications published by The Open Group in October 1997 (Document Number C706).
Continue readingIn 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.