Bookshelf Home | Contents | Index | PDF |
Siebel Analytics Server Administration Guide > SQL Reference > SQL Reference > Math FunctionsThe math functions perform mathematical operations. AbsCalculates the absolute value of a numerical expression. AcosCalculates the arc cosine of a numerical expression. AsinCalculates the arc sine of a numerical expression. AtanCalculates the arc tangent of a numerical expression. Atan2Calculates 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) CeilingRounds a noninteger numerical expression to the next highest integer. If the numerical expression evaluates to an integer, the Ceiling function returns that integer. CosCalculates the cosine of a numerical expression. CotCalculates the cotangent of a numerical expression. DegreesConverts an expression from radians to degrees. ExpSends the value e to the power specified. FloorRounds a noninteger numerical expression to the next lowest integer. If the numerical expression evaluates to an integer, the FLOOR function returns that integer. LogCalculates the natural logarithm of an expression. Log10Calculates the base 10 logarithm of an expression. ModDivides the first numerical expression by the second numerical expression and returns the remainder portion of the quotient. MOD (n_expression1, n_expression2) PiReturns the constant value of pi (the circumference of a circle divided by the diameter of a circle). PowerTakes the first numerical expression and raises it to the power specified in the second numerical expression. POWER(n_expression1, n_expression2) RadiansConverts an expression from degrees to radians. RandReturns a pseudo-random number between 0 and 1. RandFromSeedReturns a pseudo-random number based on a seed value. For a given seed value, the same set of random numbers are generated. RoundRounds a numerical expression to n digits of precision. SignReturns 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. SinCalculates the sine of a numerical expression. SqrtCalculates the square root of the numerical expression argument. The numerical expression has to evaluate to a nonnegative number. TanCalculates the tangent of a numerical expression. TruncateTruncates a decimal number to return a specified number of places from the decimal point.
|
Siebel Analytics Server Administration Guide |