abs
Returns the absolute value of x.
Examples:
examples.sql
acos
Returns the arc cosine of x.
Examples:
examples.sql
asin
Returns the arc sine of x.
Examples:
examples.sql
atan
Returns the arc tangent of x.
Examples:
examples.sql
atan2
Returns the arc tangent of y / x.
Examples:
examples.sql
cbrt
Returns the cube root of x.
Examples:
examples.sql
ceil
This is an alias for ceiling().
Examples:
examples.sql
ceiling
Returns x rounded up to the nearest integer.
Supported Signatures
cos
Returns the cosine of x.
Examples:
examples.sql
cosh
Returns the hyperbolic cosine of the given value.
Examples:
examples.sql
degrees
Converts angle x in radians to degrees.
Examples:
examples.sql
exp
Returns Euler’s number raised to the power of x.
Examples:
examples.sql
floor
Returns x rounded down to the nearest integer.
Supported Signatures
is_nan
Determine if x
is not-a-number.
Examples:
examples.sql
ln
Returns the natural logarithm of x.
Examples:
examples.sql
log
Returns the base b logarithm of x.
Examples:
examples.sql
log10
Returns the base 10 logarithm of x.
Examples:
examples.sql
log2
Returns the base 2 logarithm of x.
Examples:
examples.sql
mod
Returns the modulus (remainder) of n divided by m.
Supported Signatures
pi
Returns the constant Pi.
Examples:
examples.sql
pow
This is an alias for power().
Supported Signatures
power
Returns x raised to the power of p.
Examples:
examples.sql
radians
Converts angle x in degrees to radians.
Examples:
examples.sql
rand
This is an alias for random().
Supported Signatures
random
Returns a pseudo-random value in the range 0.0 <= x < 1.0.
Examples:
examples.sql
round
Returns x rounded to the nearest integer.
Examples:
examples.sql
sign
Returns the signum function of x, that is.
Supported Signatures
sin
Returns the sine of x.
Examples:
examples.sql
sinh
Returns the hyperbolic sine of x.
Examples:
examples.sql
sqrt
Returns the square root of x.
Examples:
examples.sql
tan
Returns the tangent of x.
Examples:
examples.sql
tanh
Returns the hyperbolic tangent of x.
Examples:
examples.sql
truncate
Returns x rounded to integer by dropping digits after decimal point.
Examples:
examples.sql