ABS (numeric_exp)

Returns the absolute (positive) value of numeric_exp.

ACOS (float_exp)

Returns the arc cosine of float_exp as an angle, expressed in radians.

ASIN (float_exp)

Returns the arc sine of float_exp as an angle, expressed in radians.

ATAN (float_exp)

Returns the arc tangent of float_exp as an angle, expressed in radians.

ATAN2 (float_exp1, float_exp2)

Returns the arc tangent of the x and y coordinates, specified by float_exp1 and float_exp2, respectively, as an angle, expressed in radians.

CEILING (numeric_exp)

Returns the smallest integer greater than or equal to numeric_exp.

COS (float_exp)

Returns the cosine of float_exp, where float_exp is an angle expressed in radians.

COT (float_exp)

Returns the cotangent of float_exp, where float_exp is an angle expressed in radians.

DEGREES (numeric_exp)

Returns the number of degrees corresponding to numeric_exp radians.

EXP (float_exp)

Returns the exponential value of float_exp.

FLOOR (numeric_exp)

Returns the largest integer less than or equal to numeric_exp.

LOG (float_exp)

Returns the natural logarithm of float_exp.

LOG10 (float_exp)

Returns the base 10 logarithm of float_exp.

MOD (integer_exp1, integer_exp2)

Returns the remainder (modulus) of integer_exp1 divided by integer_exp2.

POWER (numeric_exp, integer_exp)

Returns the value of numeric_exp to the power of integer_exp.

RADIANS (numeric_exp)

Returns the number of radians equivalent to numeric_exp degrees.

RAND (integer_exp)

Returns a random floating-point value using integer_exp as the optional seed value.

ROUND (numeric_exp, integer_exp)

Returns numeric_exp rounded to integer_exp places right of the decimal point. If integer_exp is negative, numeric_exp is rounded to |integer_exp| (absolute value of integer_exp) places to the left of the decimal point.

SIGN (numeric_exp)

Returns an indicator of the sign of numeric_exp. If numeric_exp is less than zero, -1 is returned. If numeric_exp equals zero, 0 is returned. If numeric_exp is greater than zero, 1 is returned.

SIN (float_exp)

Returns the sine of float_exp, where float_exp is an angle expressed in radians.

SQRT (float_exp)

Returns the square root of float_exp.

TAN (float_exp)

Returns the tangent of float_exp, where float_exp is an angle expressed in radians.

TRUNCATE (numeric_exp, integer_exp)

Returns numeric_exp truncated to integer_exp places right of the decimal point. If integer_exp is negative, numeric_exp is truncated to |integer_exp| (absolute value) places to the left of the decimal point.