In MariaDB, UNIX_TIMESTAMP() is a built-in date and time function that returns a Unix timestamp, based on its argument (or lack of argument).

It works like this:

• When called without an argument, it returns a Unix timestamp (seconds since ‘1970-01-01 00:00:00’ UTC) as an unsigned integer.
• When called with an argument, it returns the value of the argument as seconds since ‘1970-01-01 00:00:00’ UTC.

The inverse function of UNIX_TIMESTAMP() is FROM_UNIXTIME().

Continue reading →

In MariaDB, TIME_FORMAT() is a built-in date and time function that formats a time value according to the given format string.

It works similar to the DATE_FORMAT() function, except that the format string may only contain format specifiers for hours, minutes, and seconds.

It requires two arguments; the time and the format string.

Continue reading →

In MariaDB, TIMESTAMPDIFF() is a built-in date and time function that returns the difference between two date or datetime expressions.

Continue reading →

In MariaDB, TIMESTAMPADD() is a built-in date and time function that adds an integer expression interval to a given date or datetime expression.

Continue reading →

In MariaDB, TIMESTAMP() is a built-in date and time function that returns a datetime value, based on its argument/s.

It can be used with either one argument or two, as follows:

• When used with one argument, it returns that date or datetime expression as a datetime value.
• When used with two arguments, it adds the second (time) argument to the first (date or datetime) expression, then returns the resulting datetime value.

Continue reading →

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.

Continue reading →

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

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 →