Database Management Systems
In MariaDB, EXP() is a built-in function that returns the value of e (the base of natural logarithms) raised to the power of the argument.
The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.
The inverse of EXP() is the LN() function or LOG() function (when using the single argument syntax).
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.
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.
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 readingIn MariaDB, FLOOR() is a built-in numeric function that returns the largest integer value not greater than its argument.
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().
In MariaDB, CEILING() is a built-in numeric function that returns the smallest integer value not less than its argument.
In MariaDB, ATAN2() is a built-in numeric function that returns the arctangent (inverse tangent) of its two arguments.
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 readingIn SQL Server, you can use the MONTH() function to convert a month name to its corresponding number.