In MariaDB, UTC_DATE() is a built-in date and time function that returns the current UTC date.
The result is returned in ‘YYYY-MM-DD’ or YYYYMMDD format, depending on whether the function is used in a string or numeric context.
UTC stands for Coordinated Universal Time, and is the world standard for regulating time.
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:
The inverse function of UNIX_TIMESTAMP() is FROM_UNIXTIME().
In MariaDB, TO_SECONDS() is a built-in date and time function that returns the number of seconds from year 0 to the given date or datetime expression.
In MariaDB, TIME_TO_SEC() is a built-in date and time function that returns its time argument, converted to seconds.
SQL Server provides the STUFF() function that enables you to insert a string inside another string.
The function also allows you to specify the number of characters (if any) to delete from the original string in order to fit the new string.
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.
There are several ways to return the year from a date in SQL Server. Here are three (or is it four?).
In MariaDB, TIMESTAMPDIFF() is a built-in date and time function that returns the difference between two date or datetime expressions.
In MariaDB, TIMESTAMPADD() is a built-in date and time function that adds an integer expression interval to a given date or datetime expression.
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: