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.
Acos
Calculates the arc cosine of a numerical expression.
Asin
Calculates the arc sine of a numerical expression.
Atan
Calculates the arc tangent of a numerical expression.
Atan2
Calculates the arc tangent of y/x, where y is the first numerical expression and x is the second numerical expression.
ATAN2 (n_expression1, n_expression2)
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.
Cos
Calculates the cosine of a numerical expression.
Cot
Calculates the cotangent of a numerical expression.
Degrees
Converts an expression from radians to degrees.
Exp
Sends the value e to the power specified.
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.
Log
Calculates the natural logarithm of an expression.
Log10
Calculates the base 10 logarithm of an expression.
Mod
Divides the first numerical expression by the second numerical expression and returns the remainder portion of the quotient.
MOD (n_expression1, n_expression2)
Pi
Returns the constant value of pi (the circumference of a circle divided by the diameter of a circle).
Power
Takes the first numerical expression and raises it to the power specified in the second numerical expression.
POWER(n_expression1, n_expression2)
Radians
Converts an expression from degrees to radians.
Rand
Returns a pseudo-random number between 0 and 1.
RandFromSeed
Returns a pseudo-random number based on a seed value. For a given seed value, the same set of random numbers are generated.
Round
Rounds a numerical expression to n digits of precision.
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.
Sin
Calculates the sine of a numerical expression.
Sqrt
Calculates the square root of the numerical expression argument. The numerical expression has to evaluate to a nonnegative number.
Tan
Calculates the tangent of a numerical expression.
Truncate
Truncates a decimal number to return a specified number of places from the decimal point.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide Published: 11 March 2004 |