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.
functions
How SIGN() Works in MariaDB
In 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.
How SIN() Works in MariaDB
In MariaDB, SIN() is a built-in numeric function that returns the sine of its argument, where its argument is provided in radians.
How SYS_GUID() Works in MariaDB
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.
How UUID_SHORT() Works in MariaDB
In 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).
How UUID() Works in MariaDB
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).
How ADD_MONTHS() Works in MariaDB
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.
How PI() Works in MariaDB
In 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.
How CRC32 Works in MariaDB
In 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.
How LOG10() Works in MariaDB
In MariaDB, LOG10() is a built-in function that returns the base-10 logarithm of its argument.