In MariaDB, PERIOD_ADD() is a built-in date and time function that adds a given number of months to a period in time.
The return value is in the format YYYYMM.
Continue readingHow MAKETIME() Works in MariaDB
In MariaDB, MAKETIME() is a built-in date and time function that returns a time value, based on the hours, minutes, and seconds provided as arguments.
How MAKEDATE() Works in MariaDB
In MariaDB, MAKEDATE() is a built-in date and time function that returns a date, based on the year and day of year provided as arguments.
How GET_FORMAT() Works in MariaDB
In MariaDB, GET_FORMAT() is a built-in date and time function that returns a format string.
This function can be useful for when working with functions that require a format string, such as DATE_FORMAT() and STR_TO_DATE().
How FROM_UNIXTIME() Works in MariaDB
In MariaDB, FROM_UNIXTIME() is a built-in date and time function that returns a datetime value based on a given unix timestamp.
You pass the unix timestamp to the function when you call it.
The result is returned in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is used in a string or numeric context.
The value is expressed in the current time zone.
Continue readingHow TO_DAYS() Works in MariaDB
In MariaDB, TO_DAYS() is a built-in date and time function that returns the number of days from the start of the standard calendar (0000-00-00), based on a given date.
You pass the date to the function when you call it.
The TO_DAYS() function is the converse of the FROM_DAYS() function.
How FROM_DAYS() Works in MariaDB
In MariaDB, FROM_DAYS() is a built-in date and time function that returns a date value based on a given number of days from the start of the standard calendar (0000-00-00).
You pass the number of days to the function when you call it.
The FROM_DAYS() function is the converse of the TO_DAYS() function.
3 Ways to Get the Month Name from a Date in MariaDB
Here are three ways to return the month name from a date in MariaDB.
Continue readingHow LAST_DAY() Works in MariaDB
In MariaDB, LAST_DAY() is a built-in date and time function that returns the last day of the month for a given date.
It accepts one argument, which is the date for which you want to find the last day of the month.
Continue readingSubtract a Month from a Date in MariaDB
MariaDB provides several ways to perform arithmetic on dates. This includes adding or subtracting a month (or many months) from a given date.
Here’s an example of subtracting a month from a date in MariaDB.
Continue reading