MariaDB includes many functions for working with dates. Some of these extract certain parts from such dates and return them as a string or integer.
Below are 11 functions that you can use to return various date parts in MariaDB.
Continue readingCategory: Relational
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).
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).
Continue readingHow 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.
Continue reading