| ABS([number] x) |
Same as input |
Returns the absolute value of x. |
| ACOS([number] x) |
Double |
Calculates the arccosine of x in radians. |
| ASIN([number] x) |
Double |
Calculates the arcsine of x in radians. |
| ATAN([number] x) |
Double |
Calculates the arctangent of x in radians. |
| CBRT([number] x) |
Float |
Calculates the cube root of x. |
| CEILING([number] x) |
Same as input |
Returns the nearest whole number greater than x. |
| COS([number] x) |
Double |
Calculates the cosine of x, where x is given in radians. |
| COSH([number] x) |
Double |
Calculates the hyperbolic cosine of x. |
| COT([number] x) |
Double |
Calculates the cotangent of x, where x is given in radians. |
| DEGREES([number] x) |
Float |
Converts the value in radians given by x to degrees. |
| E() |
Float |
Returns the mathematical constant e. |
| EXP([number] x) |
Float |
Calculates the value of the constant e raised to the power of x. |
| FLOOR([number] x) |
Same as input |
Returns the nearest whole number less than x. |
| LOG([number] x) |
Float |
Calculates the natural logarithm of x. |
| LOG([number] x, [number] y) |
Float |
Calculates the log base x of y. |
| LOG10([number] x) |
Float |
Calculates the log base 10 of x. |
| LSHIFT([number] x, [number] y) |
Same as input |
Returns the binary representation of x shifted to the left by y digits. |
| MOD([number] x, [number] y) |
number |
Calculates the modulus of x and y (e.g. x % y). |
| PI |
Float |
Returns the value of the mathematical constant pi. |
| POW([number] x, [number] y) |
Float |
Calculates the x to the power of y. |
| RADIANS([number] x) |
Float |
Converts the value in degrees given by x to radians. |
| RAND([optional number] seed) |
Float |
Generates a random number between 0 and 1 for each row and invocation within a row. If a seed is provided each query generates the same random values based on the seed, which can be used during testing to verify results. |
| RANDOM([optional number] seed) |
Float |
Generates a random number between 0 and 1 for each row and invocation within a row. If a seed is provided each query generates the same random values based on the seed, which can be used during testing to verify results. |
| ROUND([number] x) |
Same as input |
Returns the whole number nearest the value x. |
| RSHIFT([number] x, [number] y) |
Same as input |
Returns the binary representation of x shifted to the right by y digits. |
| SIGN([number] x) |
Integer |
Returns the sign of x (e.g. either -1 or +1). |
| SIN([number] x) |
Double |
Calculates the sine of x, where x is given in radians. |
| SINH([number] x) |
Double |
Calculates the hyperbolic sine of x. |
| SQRT([number] x) |
Same as input |
Calculates the square root of x. |
| TAN([number] x) |
Double |
Calculates the tangent of x, where x is given in radians. |
| TANH([number] x) |
Double |
Calculates the hyperbolic tangent of x. |
| TRUNC([number] x, [optional number] y) |
Same as input |
Keeps the first y digits to right of x's decimal point. If the second argument is omitted then y = 1. |