MariaDB has a TRIM() function and a TRIM_ORACLE() function. Both functions do essentially the same thing. But there is a minor difference.
Tag: functions
How SLEEP() Works in MariaDB
In MariaDB, SLEEP() is a built-in function that sleeps (pauses) for the number of seconds specified by its argument.
If uninterrupted, it returns 0, if interrupted, it returns 1.
How OCT() Works in MariaDB
In MariaDB, OCT() is a built-in function that returns a string representation of the octal value of its argument.
How TAN() Works in MariaDB
In MariaDB, TAN() is a built-in numeric function that returns the tangent of its argument.
How SQRT() Works in MariaDB
In MariaDB, ASIN() is a built-in numeric function that returns the square root of its argument.
How TO_CHAR() Works in MariaDB
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 readingHow 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.
Continue readingHow 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).