Sphinx | Open Source Search Server

5.5.2. Numeric functions
Prev	5.5. Expressions, functions, and operators	Next

ABS(): Returns the absolute value of the argument.
CEIL(): Returns the smallest integer value greater or equal to the argument.
COS(): Returns the cosine of the argument.
EXP(): Returns the exponent of the argument (e=2.718... to the power of the argument).
FIBONACCI(): Returns the N-th Fibonacci number, where N is the integer argument. That is, arguments of 0 and up will generate the values 0, 1, 1, 2, 3, 5, 8, 13 and so on. Note that the computations are done using 32-bit integer math and thus numbers 48th and up will be returned modulo 2^32.
FLOOR(): Returns the largest integer value lesser or equal to the argument.
IDIV(): Returns the result of an integer division of the first argument by the second argument. Both arguments must be of an integer type.
LN(): Returns the natural logarithm of the argument (with the base of e=2.718...).
LOG10(): Returns the common logarithm of the argument (with the base of 10).
LOG2(): Returns the binary logarithm of the argument (with the base of 2).
MAX(): Returns the bigger of two arguments.
MIN(): Returns the smaller of two arguments.
POW(): Returns the first argument raised to the power of the second argument.
SIN(): Returns the sine of the argument.
SQRT(): Returns the square root of the argument.

Prev	Up	Next
5.5.1. Operators	Home	5.5.3. Date and time functions