Numeric Functions

Numeric functions are used to process and manipulate columns that consist of strictly numeric information, such as decimal and integer values.

Table 5-2 Numeric Functions
Function	Description
ABS (numeric_exp)	Returns the absolute 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.
PI ( )	Returns the constant value Pi as a floating point value.
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.

Examples

The following example lists the Modulus of the number and capacity columns in a table named room.

SELECT  MOD(Number, Capacity)  FROM  Room

The following example selects all salaries from a table named Faculty that are evenly divisible by 100.

SELECT Salary FROM Faculty WHERE MOD(Salary, 100) = 0