MariaDB provides several ways to perform arithmetic on dates. This includes adding or subtracting a day (or many days) from a given date.
Here’s an example of subtracting a day from a date in MariaDB.
Continue readingCategory: MariaDB
3 Ways to Get the Collations Available in MariaDB
If you need to find the collations that are available in your MariaDB installation, check out the following three methods.
Continue readingHow the JSONPath Wildcard Step (**) Works in MariaDB
When working with JSON in MariaDB, you can use JSONPath expressions to manipulate data within a JSON document.
One powerful feature that MariaDB provides is the wildcard step (**). This allows you to recursively select all child elements of the current element.
The wildcard step is a non-standard extension, and it’s also supported with the same meaning in MySQL.
Continue readingSet the Language used for Date & Time Functions in MariaDB
MariaDB has a lc_time_names system variable that controls the language used by the DAYNAME(), MONTHNAME() and DATE_FORMAT() date and time functions.
Here’s how to set the value of that variable.
Continue reading4 Functions to Return the Month from a Date in MariaDB
Below are 4 functions that enable you to return the month from a date in MariaDB.
Continue readingSet the Character Set and Collation of a Column in MariaDB
You can specify the character set and collation at various levels in MariaDB. You can specify them at the connection level, the server level, the database level, the table level, and even the column level.
You can also specify a collation in your queries so that it overrides any collation that has been previously specified at the aforementioned levels.
Continue readingHow to Check a Column’s Data Type in SQL
In SQL, the columns information schema view, which returns information about columns, is an ISO standard view that is supported by most of the major RDBMSs. You can use this view to get information about a column’s data type.
Most of the major RDBMs also provide other methods for getting column information.
Here are examples of getting the data type of a column in various SQL databases.
Continue readingReturn Only Numeric Values in MariaDB
The following MariaDB examples return only those rows that have numeric values in a given column.
These examples use the REGEXP function to return values that match the specified pattern.
2 Ways to Find Out Which Quarter a Date Belongs to in MariaDB
If you ever need to find out which quarter a date belongs to in MariaDB, here are two functions that will allow you to do just that.
Continue reading2 Ways to Get the Character Sets Available in MariaDB
If you need to find the character sets that are available in your MariaDB installation, check out the following two methods.
Continue reading