Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide > SQL Reference > SQL Reference >
Math Functions
The math functions perform mathematical operations.
Abs
Calculates the absolute value of a numerical expression.
Syntax:
ABS (n_expression)
where:
Acos
Calculates the arc cosine of a numerical expression.
Syntax:
ACOS (n_expression)
where:
Asin
Calculates the arc sine of a numerical expression.
Syntax:
ASIN (n_expression)
where:
Atan
Calculates the arc tangent of a numerical expression.
Syntax:
ATAN (n_expression)
where:
Atan2
Calculates the arc tangent of y/x, where y is the first numerical expression and x is the second numerical expression.
Syntax:
ATAN2 (n_expression1, n_expression2)
where:
Ceiling
Rounds a noninteger numerical expression to the next highest integer. If the numerical expression evaluates to an integer, the Ceiling function returns that integer.
Syntax:
CEILING (n_expression)
where:
Cos
Calculates the cosine of a numerical expression.
Syntax:
COS (n_expression)
where:
Cot
Calculates the cotangent of a numerical expression.
Syntax:
COT (n_expression)
where:
Degrees
Converts an expression from radians to degrees.
Syntax:
DEGREES (n_expression)
where:
Exp
Sends the value e to the power specified.
Syntax:
EXP (n_expression)
where:
Floor
Rounds a noninteger numerical expression to the next lowest integer. If the numerical expression evaluates to an integer, the FLOOR function returns that integer.
Syntax:
FLOOR (n_expression)
where:
Log
Calculates the natural logarithm of an expression.
Syntax:
LOG (n_expression)
where:
Log10
Calculates the base 10 logarithm of an expression.
Syntax:
LOG10 (n_expression)
where:
Mod
Divides the first numerical expression by the second numerical expression and returns the remainder portion of the quotient.
Syntax:
MOD (n_expression1, n_expression2)
where:
Pi
Returns the constant value of pi (the circumference of a circle divided by the diameter of a circle).
Syntax:
PI()
Power
Takes the first numerical expression and raises it to the power specified in the second numerical expression.
Syntax:
POWER(n_expression1, n_expression2)
where:
Radians
Converts an expression from degrees to radians.
Syntax:
RADIANS (n_expression)
where:
Rand
Returns a pseudo-random number between 0 and 1.
Syntax:
RAND()
RandFromSeed
Returns a pseudo-random number based on a seed value. For a given seed value, the same set of random numbers are generated.
Syntax:
RAND (n_expression)
where:
Round
Rounds a numerical expression to n digits of precision.
Syntax:
ROUND (n_expression, n)
where:
n_expression
Any expression that evaluates to a numerical value.n
Any positive integer representing the number of digits of precision with which to round.Sign
Returns a value of 1 if the numerical expression argument evaluates to a positive number, a value of -1 if the numerical expression argument evaluates to a negative number, and 0 if the numerical expression argument evaluates to zero.
Syntax:
SIGN (n_expression)
where:
Sin
Calculates the sine of a numerical expression.
Syntax:
SIN (n_expression)
where:
Sqrt
Calculates the square root of the numerical expression argument. The numerical expression has to evaluate to a nonnegative number.
Syntax:
SQRT (n_expression)
where:
Tan
Calculates the tangent of a numerical expression.
Syntax:
TAN (n_expression)
where:
Truncate
Truncates a decimal number to return a specified number of places from the decimal point.
Syntax:
TRUNCATE (n_expression, n)
where:
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide Published: 23 June 2003 |