📄️ abs
Returns the absolute value of the numeric value x. If the input value is NULL, NULL is returned.
📄️ acos
Computes the arc cosine of an argument.
📄️ asin
Computes the arc sine of the argument.
📄️ atan
Computes the arc tangent of the argument.
📄️ atan2
Returns the arc tangent of x divided by y, that is, the arc tangent of x/y. The signs of the two parameters are used to determine the quadrant of the result.
📄️ bin
Transforms the input arg into a binary.
📄️ cbrt
Computes the cube root of the argument.
📄️ ceil, dceil
Returns values from the input arg rounded to the nearest equal or larger integer.
📄️ ceiling
Returns values from the input arg rounded to the nearest equal or larger integer.
📄️ conv
Converts the number x from one numeric base system to another, and returns the result as a string value.
📄️ cos
Computes the cosine of the argument.
📄️ cos_similarity
Measures the similarity of two vectors by calculating the cosine of the angle between them. The angle is formed by the direction of the vectors while the difference in their magnitude is ignored.
📄️ cos_similarity_norm
Measures the similarity of two normalized vectors by calculating the cosine of the angle between them. The angle is formed by the direction of the vectors while the difference in their magnitude is ignored. This function assumes that the input vectors have been normalized. If you need to normalize vectors before calculating the cosine similarity, use cosinesimilarity.
📄️ cosh
Computes the hyperbolic cosine of the argument.
📄️ cot
Returns the cotangent of the angle in radians x. If the angle in radians x is 0 or NULL, NULL is returned.
📄️ degrees
Converts the angle in radians x to degrees.
📄️ divide
Return the quotient of x divide y. If y is 0, return null.
📄️ e
Returns the constant e (the base of natural logarithms).
📄️ exp,dexp
Returns the value of e raised to the power of x. This function is called natural logarithms function.
📄️ floor, dfloor
Returns the largest integer that is not more than x.
📄️ fmod
Returns the floating point remainder of the division ( dividend/divisor ). It is a modulo function.
📄️ greatest
Returns the largest value from a list of one or more parameters.
📄️ least
Returns the smallest value from a list of one or more parameters.
📄️ ln, dlog1, log
Computes the natural (base e) logarithm of a number.
📄️ log
Calculates the logarithm of a number to a specified base (or radix). If the base is not specified, this function is equivalent to ln.
📄️ log10, dlog10
Calculates the base 10 logarithm of a number.
📄️ log2
Calculates the base 2 logarithm of a number.
📄️ mod
The modulus function that returns the remainder of dividend divided by divisor.
📄️ multiply
Computes the product of the arguments.
📄️ negative
Returns the negative of input arg.
📄️ pi
Returns the value of Pi.
📄️ pmod
Returns the positive remainder of dividend divided bydivisor.
📄️ positive
Returns x as a value.
📄️ pow, power, dpow, fpow
Returns the result of x raised to the power of y.
📄️ radians
Converts x from an angle to a radian.
📄️ rand, random
Returns a random floating-point number between 0 (inclusive) and 1 (exclusive).
📄️ round, dround
Rounds a number to a specified number of digits.
📄️ sign
Returns the sign of x. A negative number, 0, or a positive number as input corresponds to -1, 0, or 1 as output, respectively.
📄️ sin
Returns the sine of x, where x is in radians.
📄️ sinh
Computes the hyperbolic sine of the argument.
📄️ sqrt, dsqrt
Calculates the square root of a value. dsqrt is same as sqrt.
📄️ square
Calculates the square of a value.
📄️ tan
Returns the tangent of x, where x is in radians.
📄️ tanh
Computes the hyperbolic tangent of the argument.
📄️ truncate
Rounds the input down to the nearest equal or smaller value with the specified number of places after the decimal point.