Numeric functions

The following table describes the supported numeric functions.

Function	Description
ABS	Returns the absolute value of n.
ACOS	Returns the arc cosine of n.
ASIN	Returns the arc sine of n.
ATAN	Returns the arc tangent of n.
ATAN2	Returns the arc tangent of n1 and n2.
BITAND	Treats its inputs and its output as vectors of bits and returns the bitwise AND of the inputs.
CEIL	Returns the smallest integer that is greater than or equal to n.
COS	Returns the cosine of n (an angle expressed in radians).
COSH	Returns the hyperbolic cosine of n.
EXP	Returns e raised to the nth power, where e = 2.71828183… . Thw value returned is of the same type as the argument.
FLOOR	Returns the largest integer equal to or less than n.
LN	Returns the natural logarithm of n, where n is greater than 0.
LOG	Returns the logarithm, base n2, of n1. The base n2 can be any positive value other than 0 or 1 and n1 can be any positive value.
MOD	Returns the remainder of n2 divided by n1. Returns n2 if n1 is 0.
NANVL	Returns the value of n1 if n2 is NaN; otherwise returns n2. Supports numeric data types and nonnumeric types that can be implicitly converted to a numeric type.
POWER	Returns n2 raised to the n1 power. The base n2 and the exponent n1 can be any numbers, but if n2 is negative, then n1 must be an integer.
REMAINDER	Returns the remainder of n2 divided by n1.
ROUND	Returns n rounded to the specified number of decimal places. If integer is omitted, n is rounded to zero decimal places. If integer is negative, n is rounded to the left of the decimal point.
SIGN	Returns the sign of n. Accepts any numeric data type, or a nonnumeric data type that can be implicitly converted to NUMBER, and returns NUMBER.
SIN	Returns the sine of n (an angle expressed in radians).
SINH	Returns the hyperbolic sine of n.
SQRT	Returns the square root of n.
TAN	Returns the tangent of n (an angle expressed in radians).
TANH	Returns the hyperbolic tangent of n.
TRUNC	Returns n1 truncated to n2 decimal places. If n2 is omitted, n1 is truncated to zero decimal places. If n2 is negative, truncation occurs to the left of the decimal point.
WIDTH_BUCKET	Returns the bucket number into which a given expression falls in an equiwidth histogram, where the histogram range is divided into intervals of equal size. Buckets are represented as closed-open intervals, for example [10, 20).