acos
Compute the arccosine of the input expression (returned as radians).
Supported Signatures
function acos(double) returns double
🔗 Official Documentation
acosh
Compute the inverse hyperbolic cosine of the input expression.
Supported Signatures
function acosh(double) returns double
🔗 Official Documentation
asin
Compute the arcsine of the input expression (returned as radians).
Supported Signatures
function asin(double) returns double
🔗 Official Documentation
asinh
Compute the inverse hyperbolic sine of the input expression.
Supported Signatures
function asinh(double) returns double
🔗 Official Documentation
atan
Compute the arctangent of the input expression (returned as radians).
Supported Signatures
function atan(double) returns double
🔗 Official Documentation
atan2
Compute the angle (in radians) between the x-axis and point (x, y).
Supported Signatures
function atan2(double, double) returns double
🔗 Official Documentation
atanh
Compute the inverse hyperbolic tangent of the input expression (as radians).
Supported Signatures
function atanh(double) returns double
🔗 Official Documentation
cbrt
Compute the cubic root of the input expression.
Supported Signatures
function cbrt(double) returns double
🔗 Official Documentation
ceil
round to the nearest integer not smaller than input
Supported Signatures
function ceil(decimal(38, 0)) returns decimal(38, 0)
function ceil(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function ceil(double) returns double
function ceil(double, decimal(38, 0)) returns double
🔗 Official Documentation
cos
Compute the cosine of the input expression (as radians).
Supported Signatures
function cos(double) returns double
🔗 Official Documentation
cosh
Compute the hyperbolic cosine of the input expression.
Supported Signatures
function cosh(double) returns double
🔗 Official Documentation
cot
Compute the cotangent of the input expression (as radians).
Supported Signatures
function cot(double) returns double
🔗 Official Documentation
degrees
convert r (radians) to degrees.
Supported Signatures
function degrees(double) returns double
🔗 Official Documentation
div0
Divides two numbers; returns 0 if divisor is 0
Supported Signatures
function div0(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function div0(double, double) returns double
🔗 Official Documentation
div0null
Divides two numbers; returns 0 if divisor is 0 or null
Supported Signatures
function div0null(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function div0null(double, double) returns double
🔗 Official Documentation
exp
returns e raised to the x’th power
Supported Signatures
function exp(double) returns double
🔗 Official Documentation
factorial
Factorial of f
Supported Signatures
function factorial(decimal(38, 0)) returns decimal(38, 0)
🔗 Official Documentation
floor
round to the nearest integer not greater than input
Supported Signatures
function floor(decimal(38, 0)) returns decimal(38, 0)
function floor(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function floor(double) returns double
function floor(double, decimal(38,0)) returns double
🔗 Official Documentation
returns the natural logarithm of a
Supported Signatures
function ln(double) returns double
🔗 Official Documentation
log
returns the logarithm base b of a
Supported Signatures
function log(double, double) returns double
🔗 Official Documentation
mod
Computes modulo of two numbers
Supported Signatures
function mod(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function mod(double, double) returns double
🔗 Official Documentation
Returns the constant pi.
Supported Signatures
function pi() returns double
🔗 Official Documentation
pow
returns x raised to the y’th power
Supported Signatures
function pow(double, double) returns double
🔗 Official Documentation
power
returns x raised to the y’th power
Supported Signatures
function power(double, double) returns double
🔗 Official Documentation
radians
convert d (degrees) to radians.
Supported Signatures
function radians(double) returns double
🔗 Official Documentation
round
round to the nearest integer, with .5 rounded away from 0
Supported Signatures
function round(double) returns double
function round(double, double) returns double
function round(double, double, varchar) returns double
function round(decimal(38, 0)) returns decimal(38, 0)
function round(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function round(decimal(38, 0), decimal(38, 0), varchar) returns decimal(38, 0)
function round() returns bigint
🔗 Official Documentation
sign
returns sign of x
Supported Signatures
function sign(decimal(38, 0)) returns decimal(38, 0)
function sign(double) returns double
🔗 Official Documentation
sin
Compute the sine of the input expression (as radians).
Supported Signatures
function sin(double) returns double
🔗 Official Documentation
sinh
Compute the hyperbolic sine of the input expression.
Supported Signatures
function sinh(double) returns double
🔗 Official Documentation
sqrt
Compute the square root of the input expression.
Supported Signatures
function sqrt(double) returns double
🔗 Official Documentation
square
Compute the square of the input expression.
Supported Signatures
function square(double) returns double
🔗 Official Documentation
tan
Compute the tangent of the input expression (as radians).
Supported Signatures
function tan(double) returns double
🔗 Official Documentation
tanh
Compute the hyperbolic tangent of the input expression (as radians).
Supported Signatures
function tanh(double) returns double
🔗 Official Documentation
truncate
truncate the fractional or date part
Supported Signatures
function truncate(decimal(38, 0)) returns decimal(38, 0)
function truncate(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function truncate(double) returns double
function truncate(double, double) returns double
function truncate(date, varchar) returns date
function truncate(time, varchar) returns time
function truncate(timestamp, varchar) returns timestamp
🔗 Official Documentation
width_bucket
returns the bucket a value falls into in an equiwidth histogram
Supported Signatures
function width_bucket(decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function width_bucket(double, double, double, decimal(38, 0)) returns decimal(38, 0)
🔗 Official Documentation
