MariaDB provides several ways to perform arithmetic on dates. This includes adding or subtracting a month (or many months) from a given date.
Here are 6 ways to add a month to a date in MariaDB.
Bonus update: I’ve now added a 7th way to add a month to a date at the end of this article. So I guess it’s now 7 ways to add a month to a date in MariaDB 🙂
Continue readingIn MariaDB, DAYNAME() is a built-in date and time function that returns the name of the weekday for a given date.
It accepts one argument, which is the date you want to extract the day name from.
Continue readingMariaDB 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 return the value of that variable.
Continue readingIn MariaDB, DAY() is a synonym for DAYOFMONTH(). It returns the day of the month from a given date.
In MariaDB, DAYOFMONTH() is a built-in date and time function that returns the day of the month from a given date.
It accepts one argument, which is the date you want to extract the day of the month from.
The result is in the range 1 to 31. However, if the date has a zero day part (for example '0000-00-00' or '2021-00-00'), the result is 0.
MariaDB supports a large list of locales that are used by functions such as DAYNAME(), MONTHNAME() and DATE_FORMAT().
While these locales are available to MariaDB, by default they’re not loaded into any of the system tables, so you can’t run a query to retrieve them.
However, MariaDB provides a plugin that does load these into a table. Once the plugin has been installed, you can query that table to return the locales available in MariaDB.
Continue readingBelow is a full list of date and time locales available in MariaDB.
Continue readingIn MariaDB, DATE_FORMAT() is a built-in date and time function that formats a date according to the given format string.
It requires two arguments; the date and the format string. It also accepts an optional third argument that allows you to specify the locale.
Continue readingBelow is a full list of format specifiers that can be used in format strings with functions like DATE_FORMAT(), STR_TO_DATE(), and FROM_UNIXTIME() in MariaDB.
In MariaDB, DATEDIFF() is a built-in date and time function that returns the difference, in days, between two dates.
It accepts two arguments, both of which are date or datetime expressions. It then subtracts the second date from the first.
Continue reading