In MariaDB, RADIANS() is a built-in function that returns its argument converted from degrees to radians.
The RADIANS() function is the converse of the DEGREES() function.
Author: Ian
How DEGREES() Works in MariaDB
In MariaDB, DEGREES() is a built-in function that returns its argument converted from radians to degrees.
The DEGREES() function is the converse of the RADIANS() function.
3 Ways to Convert a Date to a String in MongoDB
MongoDB has a Date BSON type that allows you to store dates as dates.
You can also store dates as strings, if that’s what you need.
Taking it a step further, you can also convert a Date to a string.
This article presents three ways to convert a Date to a string in MongoDB.
Continue readingHow FLOOR() Works in MariaDB
In MariaDB, FLOOR() is a built-in numeric function that returns the largest integer value not greater than its argument.
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 reading