MariaDB has an HOUR() function that extracts the hour portion from a time value. MariaDB also has an EXTRACT() function that can also extract the hour portion from a time value.
However, these functions don’t always return the same result.
Read on to see the difference between HOUR() and EXTRACT(HOUR FROM ...) in MariaDB.
MariaDB has a TRIM() function and a TRIM_ORACLE() function. Both functions do essentially the same thing. But there is a minor difference.
Below are 4 functions that enable you to return the microseconds part from a time value in MariaDB.
Continue readingIn 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.
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 readingIf 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.
In MariaDB, OCT() is a built-in function that returns a string representation of the octal value of its argument.
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 readingIn MariaDB, TAN() is a built-in numeric function that returns the tangent of its argument.
In MariaDB, ASIN() is a built-in numeric function that returns the square root of its argument.