In MariaDB, ATAN() is a built-in numeric function that returns the arctangent (inverse tangent) of its argument.
In other words, it returns the value whose tangent is the argument.
Continue readingTag: what is
How UTC_TIMESTAMP() Works in MariaDB
In MariaDB, UTC_TIMESTAMP() is a built-in date and time function that returns the current UTC date and time.
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.
UTC stands for Coordinated Universal Time, and is the world standard for regulating time.
Continue readingHow UTC_TIME() Works in MariaDB
In MariaDB, UTC_TIME() is a built-in date and time function that returns the current UTC time.
The result is returned in ‘HH:MM:SS’ or HHMMSS.uuuuuu 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.
Continue readingHow UTC_DATE() Works in MariaDB
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.
Continue readingHow UNIX_TIMESTAMP() Works in MariaDB
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().
How TO_SECONDS() Works in MariaDB
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.
How TIME_TO_SEC() Works in MariaDB
In MariaDB, TIME_TO_SEC() is a built-in date and time function that returns its time argument, converted to seconds.
How TIME_FORMAT() Works in MariaDB
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 readingHow TIMESTAMPDIFF() Works in MariaDB
In MariaDB, TIMESTAMPDIFF() is a built-in date and time function that returns the difference between two date or datetime expressions.
How TIMESTAMPADD() Works in MariaDB
In MariaDB, TIMESTAMPADD() is a built-in date and time function that adds an integer expression interval to a given date or datetime expression.