Database Management Systems
In MariaDB, COT() is a built-in numeric function that returns the cotangent of its argument.
In trigonometry, in a right triangle, the cotangent of an angle is the length of the adjacent side divided by the length of the opposite side.
Continue readingIn MariaDB, COS() is a built-in numeric function that returns the cosine of its argument, where the argument is provided in radians.
In MariaDB, LOG() is a built-in function that returns the natural logarithm of its argument to a given base.
It can be called with one or two arguments:
When called with a single argument, LOG() is the inverse of EXP(), and it’s the same as using LN().
In MariaDB, LN() is a built-in function that returns the natural logarithm of its argument. In other words, it returns the base-e logarithm of its argument.
The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.
LN() is the inverse of EXP(), and it’s the same as using LOG() with the single argument syntax.
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().