> ## Documentation Index > Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt > Use this file to discover all available pages before exploring further. # Math Functions ## Math Functions Calculates the absolute value of `expr` Returns the inverse cosine (arccosine) of `expr` as a *double* Returns the inverse cosine (arccosine) of `expr` as a *float* Returns the inverse hyperbolic cosine of `expr` as a *double* Returns the inverse hyperbolic cosine of `expr` as a *float* Returns the inverse sine (arcsine) of `expr` as a *double* Returns the inverse sine (arcsine) of `expr` as a *float* Returns the inverse hyperbolic sine of `expr` as a *double* Returns the inverse hyperbolic sine of `expr` as a *float* Returns the inverse tangent (arctangent) of `expr` as a *double* Returns the inverse tangent (arctangent) of `expr` as a *float* Returns the inverse hyperbolic tangent of `expr` as a *double* Returns the inverse hyperbolic tangent of `expr` as a *float* Returns the inverse tangent (arctangent) using two arguments as a *double* Returns the inverse tangent (arctangent) using two arguments as a *float* Alias for `ATAN2` Alias for `ATAN2F` Returns the cube root of `expr` as a *double* Returns the cube root of `expr` as a *float* Alias for `CEILING` Rounds `expr` up to the next highest integer Returns the cosine of `expr` as a *double* Returns the cosine of `expr` as a *float* Returns the hyperbolic cosine of `expr` as a *double* Returns the hyperbolic cosine of `expr` as a *float* Returns the cotangent of `expr` as a *double* Returns the cotangent of `expr` as a *float* Returns the conversion of `expr` (in radians) to degrees as a *double* Returns the conversion of `expr` (in radians) to degrees as a *float* Returns the quotient `a / b` unless `b == 0`, in which case it returns `c` Returns *e* to the power of `expr` as a *double* Returns *e* to the power of `expr` as a *float* Rounds `expr` down to the next lowest integer Returns whichever of `expr_a` and `expr_b` has the larger value, based on typed comparison Returns the hypotenuse of `x` and `y` as a *double* Returns the hypotenuse of `x` and `y` as a *float* Alias for `IF_ERROR(expr, val)` Alias for `IF_INF(expr, val)` Alias for `IF_INF(expr, val)` Alias for `IF_NAN(expr, val)` Evaluates the given *double* or *float* `expr`, and if it resolves to infinity or `NaN`, return `val` Conceptually, this function is the same as `IF_INF(IF_NAN(expr, val), val)` Example:
Function Call Result
IF\_ERROR((double(10)/0), 1) 1.0
IF\_ERROR(log(-1), 1) 1.0
Evaluates the given *double* or *float* `expr`, and if it resolves to infinity, return `val` Example:
Function Call Result
IF\_INF((double(10)/0), 999) 999.0
IF\_INF(log(-1), 999) NaN
Alias for `IF_INF(expr, val)` Evaluates the given *double* or *float* `expr`, and if it resolves to `NaN`, return `val` Example:
Function Call Result
IF\_NAN((double(10)/0), -1) Infinity
IF\_NAN(log(-1), -1) -1.0
Returns `1` (true) if `expr` is infinity by IEEE standard; otherwise, returns `0` (false) Alias for `ISINFINITY` Returns `1` (true) if `expr` is not a number by IEEE standard; otherwise, returns `0` (false) Alias for `ISNAN` Returns `1` (true) if `expr` is a number by IEEE standard; otherwise, returns `0` (false) Alias for `ISNUMERIC` Returns the value of `x` \* 2exp as a *double* Returns the value of `x` \* 2exp as a *float* Returns whichever of `expr_a` and `expr_b` has the smaller value, based on typed comparison Returns the natural logarithm of `expr` as a *double* Returns the natural logarithm of `expr` as a *float* Alias for `LN` Returns the *base-10* logarithm of `expr` as a *double* Returns the *base-10* logarithm of `expr` as a *float* Returns the natural logarithm of one plus `expr` as a *double* Returns the natural logarithm of one plus `expr` as a *float* Returns the binary (*base-2*) logarithm of `expr` as a *double* Returns the binary (*base-2*) logarithm of `expr` as a *float* Alias for `LNF` Calculates the length of the longest series of consecutive `1` bits in the integer `expr` Calculates the remainder after integer division of `dividend` by `divisor` Returns the value of *pi* Alias for `POWER` Alias for `POWERF` Returns `base` raised to the power of `exponent` as a *double* Returns `base` raised to the power of `exponent` as a *float* Returns the conversion of `expr` (in degrees) to radians as a *double* Returns the conversion of `expr` (in degrees) to radians as a *float* Returns a random floating-point value, with an optional `seed` Returns NULL if `y` is NULL; otherwise, returns `x` Returns NULL if `x` is NULL; otherwise, returns `y` Rounds `expr` to the nearest decimal number with `scale` decimal places when `scale` is a positive number; rounds to the nearest number such that the result has `-(scale)` zeros to the left of the decimal point when `scale` is negative; use `scale` of `0` to round to the nearest integer. The default value of `scale` is `0`. Examples:
Function Call Result
ROUND(12345.678) 12346
ROUND(12345.678, 2) 12345.68
ROUND(12345.678, 0) 12346
ROUND(12345.678, -2) 12300
Determines whether a number is positive, negative, or zero; returns one of the following three values:
Expression Value Result
*positive* 1
*zero* 0
*negative* -1
Returns the sine of `expr` as a *double* Returns the sine of `expr` as a *float* Returns the hyperbolic sine of `expr` as a *double* Returns the hyperbolic sine of `expr` as a *float* Returns the square root of `expr` as a *double* Returns the square root of `expr` as a *float* Returns the tangent of `expr` as a *double* Returns the tangent of `expr` as a *float* Returns the hyperbolic tangent of `expr` as a *double* Returns the hyperbolic tangent of `expr` as a *float* Rounds `expr` down to the nearest decimal number with `scale` decimal places when `scale` is a positive number; rounds down to the nearest number such that the result has `-(scale)` zeros to the left of the decimal point when `scale` is negative; use `scale` of `0` to round down to the nearest integer. The default value of `scale` is `0`. Examples:
Function Call Result
TRUNCATE(12345.678) 12345
TRUNCATE(12345.678, 2) 12345.67
TRUNCATE(12345.678, 0) 12345
TRUNCATE(12345.678, -2) 12300
Defines a set of `count` equal intervals (buckets) within the range of `min` & `max`, and puts the value of `expr` into one of those buckets, where the value is greater than or equal to the minimum value of the bucket and less than the maximum value of the bucket. Returns the 1-based number of the bucket into which the value of `expr` fell. For values smaller than `min`, `0` is returned; for values greater than or equal to `max`, `count + 1` is returned. Examples: In the following examples, a set of *5* equal buckets are defined between *0* and *10* (*0-2*, *2-4*, *4-6*, *6-8*, & *8-10*), and various values are bucketed using that set.
Function Call Result
WIDTH\_BUCKET(-1, 0, 10, 5) 0
WIDTH\_BUCKET(0, 0, 10, 5) 1
WIDTH\_BUCKET(5, 0, 10, 5) 3
WIDTH\_BUCKET(10, 0, 10, 5) 6
WIDTH\_BUCKET(11, 0, 10, 5) 6