In MariaDB, TIMEDIFF() is a built-in date and time function that returns the difference between two time values or datetime values, expressed as a time value.
It’s similar to the DATEDIFF() function, except that DATEDIFF()‘s return value is expressed in days.
TIMEDIFF() accepts two arguments, both of which are time or datetime expressions. It then subtracts the second time from the first.
In MariaDB, TIME() is a built-in date and time function that extracts the time part from a given time or datetime expression and returns it as a string.
It accepts one argument, which is the time or datetime value for which you want to extract the time.
Continue readingIn 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 readingIn MariaDB, STR_TO_DATE() is a built-in date and time function that returns a datetime value, based on the given date string and format string.
The STR_TO_DATE() function is the inverse of the DATE_FORMAT() function.
In MariaDB, SEC_TO_TIME() is a built-in date and time function that returns a time value, based on the number of seconds provided as arguments.
In MariaDB, PERIOD_DIFF() is a built-in date and time function that returns the number of months between two periods.
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 readingIn 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.
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.
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().