In MariaDB, BENCHMARK() is a built-in function that executes an expression a specified number of times.
It can be used to time how quickly MariaDB processes the expression.
The result is always 0. The function is intended to be used within the mysql command line tool, which reports query execution times.
If you’re trying to run SHOW LOCALES but it’s not working, it’s probably because the LOCALES plugin hasn’t been installed yet. Installing that plugin should hopefully fix the problem.
This article contains a full list of built-in MariaDB date and time functions.
Continue readingThere are several ways to get the language currently being used in SQL Server.
The language of the current session will often be the default language for the login, but this is not necessarily always the case. A user can change the current language during the session.
Also, some of SQL Server’s built-in functions accept an argument that allows you to specify a language for that specific query.
This article shows you how to return the language currently being used.
Continue readingMariaDB 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.
If you’re new to relational databases, and you’re trying to get your head around this concept of a “relationship” in your database, I hope this article helps.
Continue readingTSQL provides the DATEPART() function, which enables us to return the day of the year for a given date in SQL Server.
By “day of the year”, I mean the day number of the given year.
Continue readingMariaDB 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 readingMongoDB includes the $strLenBytes and $strLenCP operators in its aggregation pipeline framework. These operators do a similar but slightly different thing. In some cases, both will return exactly the same result, while in other cases the results will differ.
Here’s a quick overview of the difference between these two operators.
Continue reading