Math

Function Name	Description
ABS	Computes the absolute value of a numeric expression.
ACOS	Computes the arccosine (inverse cosine) of a value in radians.
ASIN	Computes the arcsine (inverse sine) of a value in radians.
ATAN	Computes the Arctangent (inverse tangent) of a value.
CBRT	Computes the cube root of a numeric expression.
CEILING	Returns the nearest equal or larger value of the input expression. Can also be called using CEIL().
COS	Computes the cosine of a value in radians.
COSH	Computes the hyperbolic cosine of a value in radians.
COT	Computes the cotangent of a value in radians.
DEGREES	Converts radians to degrees.
E	Returns Euler’s number, a constant approximately equal to 2.718281828459045.
EXP	Calculates Euler’s number, e, raised to the power of the specified value.
FLOOR	Returns the value from the specified expression rounded to the nearest equal or smaller integer.
LOG	Returns the logarithm of the numeric input expression. If no base is specified, the natural log (ln) will be calculated.
LOG10	Returns the log base 10 of the numeric input expression.
MOD	Returns the remainder of the input expression divided by the second input expression.
PI	Returns the value of pi, which is approximately 3.14592654.
POWER	Returns the result of raising the input value to the specified power.
RADIANS	Convert a value in degrees to radians.
ROUND	Returns the rounded value for the inputted value. If no scale is specified, the closest whole number is returned.
SIGN	Returns the sign of the input expression.
SIN	Computes the sine of a value.
SINH	Computes the hyperbolic sine of the input expression.
SQRT	Returns the square root of the non-negative numeric expression.
STDDEV	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.
STDDEV_POP	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.
STDDEV_SAMP	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.
TAN	Computes the tangent of a value in radians.
TANH	Computes the hyperbolic tangent of the input expression.
TRUNCATE	Rounds the input expression down the nearest of equal integer depending on the specified number of places before or after the decimal point.