Math
Last updated
Last updated
Function Name | Description |
---|---|
Computes the absolute value of a numeric expression.
Computes the arccosine (inverse cosine) of a value in radians.
Computes the arcsine (inverse sine) of a value in radians.
Computes the Arctangent (inverse tangent) of a value.
Computes the cube root of a numeric expression.
Returns the nearest equal or larger value of the input expression. Can also be called using CEIL().
Computes the cosine of a value in radians.
Computes the hyperbolic cosine of a value in radians.
Computes the cotangent of a value in radians.
Converts radians to degrees.
Returns Eulerβs number, a constant approximately equal to 2.718281828459045.
Calculates Eulerβs number, e, raised to the power of the specified value.
Returns the value from the specified expression rounded to the nearest equal or smaller integer.
Returns the logarithm of the numeric input expression. If no base is specified, the natural log (ln) will be calculated.
Returns the log base 10 of the numeric input expression.
Returns the remainder of the input expression divided by the second input expression.
Returns the value of pi, which is approximately 3.14592654.
Returns the result of raising the input value to the specified power.
Convert a value in degrees to radians.
Returns the rounded value for the inputted value. If no scale is specified, the closest whole number is returned.
Returns the sign of the input expression.
Computes the sine of a value.
Computes the hyperbolic sine of the input expression.
Returns the square root of the non-negative numeric expression.
Returns the standard deviation of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
Returns the population standard deviation (square root of variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
Returns the sample standard deviation (square root of sample variance) of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.
Computes the tangent of a value in radians.
Computes the hyperbolic tangent of the input expression.
Rounds the input expression down the nearest of equal integer depending on the specified number of places before or after the decimal point.