In Oracle, the LN() function returns the natural logarithm of its argument, where the argument is greater than 0.
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.
Continue readingMongoDB’s aggregation pipeline framework includes a $round operator and a $trunc operator. These operators perform similar, but different tasks.
In Oracle, the ATAN2() function returns the arctangent (inverse tangent) of its two arguments.
In Oracle, the ATAN() function returns the arctangent (inverse tangent) of its argument.
In other words, it returns the value whose tangent is the argument.
Continue readingIn Oracle, the BITAND() function returns a bitwise AND of its two arguments.
In Oracle, the ASIN() function returns the arcsine (inverse sine) of its argument.
In other words, it returns the value whose sine is the argument.
Continue readingIn MariaDB, JSON_VALID() is a built-in function that allows you to check whether or not a value is a valid JSON document.
You pass the value as an argument, and JSON_VALID() returns 1 if it’s a valid JSON document, and 0 if not.
In Oracle, the ACOS() function returns the arccosine (inverse cosine) of its argument.
In other words, it returns the value whose cosine is the argument.
Continue readingIn Oracle, the ABS() function returns the absolute value of its argument.
The absolute value is the non-negative value of a real number without regard to its sign. It describes the distance from zero that a number is on the number line, without considering direction.
Continue readingIn MariaDB, JSON_UNQUOTE() is a built-in function that removes quotes from a JSON value. In other words, it “unquotes” a JSON value.