In MariaDB, SYSDATE() is a built-in date and time function that returns the current date and time.

It returns the time that the function was executed (which could be different to the time that the statement was executed).

The return value 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 return value is expressed in the current time zone.

You also have the option of specifying the microsecond precision.

Continue reading →

In MariaDB, PERIOD_DIFF() is a built-in date and time function that returns the number of months between two periods.

Continue reading →

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 reading →

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.

Continue reading →

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.

Continue reading →

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().

Continue reading →

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 reading →