Please use the links in the table below to view the eXtremeSQL math functions:
abs(a) Returns the absolute value of the specified expression (of type integerorreal)acos(r) Returns the arcos (inverse cosine) of the specified expression (of type real)asin(r) Returns the arcsin (inverse sine) of the specified expression (of type real)atan(r) Returns the arctan (inverse tangent) of the specified expression (of type real)ceil(r) Returns the value rounded up to the next whole number cos(r) Returns the cosine of the specified expression (of type real)exp(r) Returns the exponential function, e to the power of r floor(r) Returns the value rounded down to the next whole number int[eger](r) Returns the integer value or the expression (of type real)log(r) Returns the logarithm (base 10) of the specified expression (of type real)mod(r,v) Returns the modulo of the specified expression (remainder of r divided by v) real(i) Returns the real value or the expression (of type integer)rnd() Returns a random double value between 0.0 and 1.0 round(r,p) Rounds a real expression r to the number of decimals specified by precision p sin(r) Returns the sine of the specified expression (of type real)sqrt(r) Returns the square root of r tan(r) Returns the tangent of the specified expression (of type real)xor(r1, r2) Returns the XOR for realexpressions r1 and r2