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.
3 Ways to Get the Day Name from a Date in MariaDB
Below are three approaches you can use to get the day name from a date in MariaDB.
Two of these approaches return the full day name, and one returns the short day name.
Continue readingFix: “Unknown table ‘locales’ in information_schema” in MariaDB
If you get the Unknown table 'locales' in information_schema error in MariaDB, it’s probably because you haven’t installed the LOCALES plugin yet.
You need to install the LOCALES plugin before you try to query this table.
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.
11 Functions to Get the Day, Month, and Year from a Date in MariaDB
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 readingHow 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.