In MariaDB, FLOOR() is a built-in numeric function that returns the largest integer value not greater than its argument.
Category: DBMS
Database Management Systems
MariaDB CEIL() Explained
In MariaDB, CEIL() is a built-in numeric function that returns the smallest integer value not less than its argument.
CEIL() is a synonym for CEILING().
How CEILING() Works in MariaDB
In MariaDB, CEILING() is a built-in numeric function that returns the smallest integer value not less than its argument.
How ATAN2() Works in MariaDB
In MariaDB, ATAN2() is a built-in numeric function that returns the arctangent (inverse tangent) of its two arguments.
How ATAN() Works in MariaDB
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 readingConvert a Month Name to the Month Number in SQL Server (T-SQL)
In SQL Server, you can use the MONTH() function to convert a month name to its corresponding number.
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().