Numeric Functions (ODBC Scalar Functions)

Function

Description

ABS (numeric_exp)

Absolute value.

ACOS (float_exp)

Arc cosine as an angle expressed in radians

ASIN (float_exp)

Arc sine as an angle expressed in radians

ATAN (float_exp)

Arc tangent as an angle expressed in radians

ATAN2 (float_exp1, float_exp2)

Arc tangent of the x- and y-coordinates specified by float_exp1 and float_exp2 as an angle expressed in radians

CEILING (numeric_exp)

Smallest integer greater than or equal to numeric_exp.

COS (float_exp)

The cosine of float_exp where float_exp is an angle expressed in radians.

COT (float_exp)

The cotangent of float_exp where float_exp is an angle expressed in radians.

DEGREES (numeric_exp)

Converts to the number of degrees where numeric_exp is an angle expressed in radians.

EXP (float_exp)

Exponential value of float_exp

FLOOR (numeric_exp)

Largest integer less than or equal to numeric_exp.

LOG (float_exp)

Natural logarithm of float_exp.

LOG10 (float_exp)

Base 10 logarithm of float_exp.

MOD (integer_exp1, integer_exp2)

Remainder (modulus) of integer_exp1 divided by integer_exp2.

PI ()

Constant value of pi.

POWER (numeric_exp, integer_exp)

Numeric_exp to the power of integer_exp.

RADIANS (numeric_exp)

Converts to the number of radians where numeric_exp is an angle expressed in degrees.

RAND ([integer_exp])

Random number using the optional integer_exp as seed value.

ROUND (numeric_exp, integer_exp)

Numeric_exp rounded to integer_exp positions right of the decimal separator.

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 is zero, 0 is returned. If numeric_exp is greater than zero, 1 is returned.

SIN (float_exp)

The sine of float_exp where float_exp is an angle expressed in radians.

SQRT (float_exp)

Square root of float_exp.

TAN (float-exp)

The tangent of float_exp where float_exp is an angle expressed in radians.

TRUNCATE (numeric_exp, integer_exp)

Numeric_exp truncated to integer_exp positions right of the decimal separator.

 

See Also

ODBC Escape Sequences

String Functions

Time, Date and Interval Functions

System Functions

Data Type Conversion Functions