Numeric Functions
acos
Compute the arccosine of the input expression (returned as radians). Supported Signatures
function acos(double) returns double
acosh
Compute the inverse hyperbolic cosine of the input expression. Supported Signatures
function acosh(double) returns double
asin
Compute the arcsine of the input expression (returned as radians). Supported Signatures
function asin(double) returns double
asinh
Compute the inverse hyperbolic sine of the input expression. Supported Signatures
function asinh(double) returns double
atan
Compute the arctangent of the input expression (returned as radians). Supported Signatures
function atan(double) returns double
atan2
Compute the angle (in radians) between the x-axis and point (x, y). Supported Signatures
function atan2(double, double) returns double
atanh
Compute the inverse hyperbolic tangent of the input expression (as radians). Supported Signatures
function atanh(double) returns double
cbrt
Compute the cubic root of the input expression. Supported Signatures
function cbrt(double) returns double
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, double) returns double
cos
Compute the cosine of the input expression (as radians). Supported Signatures
function cos(double) returns double
cosh
Compute the hyperbolic cosine of the input expression. Supported Signatures
function cosh(double) returns double
cot
Compute the cotangent of the input expression (as radians). Supported Signatures
function cot(double) returns double
degrees
convert r (radians) to degrees. Supported Signatures
function degrees(double) returns double
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
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
exp
returns e raised to the x’th power Supported Signatures
function exp(double) returns double
factorial
Factorial of f Supported Signatures
function factorial(decimal(38, 0)) returns decimal(38, 0)
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, double) returns double
ln
returns the natural logarithm of a Supported Signatures
function ln(double) returns double
log
returns the logarithm base b of a Supported Signatures
function log(double, double) returns double
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
pi
Returns the constant pi. Supported Signatures
function pi() returns double
pow
returns x raised to the y’th power Supported Signatures
function pow(double, double) returns double
power
returns x raised to the y’th power Supported Signatures
function power(double, double) returns double
radians
convert d (degrees) to radians. Supported Signatures
function radians(double) returns double
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)) 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
sign
returns sign of x Supported Signatures
function sign(decimal(38, 0)) returns decimal(38, 0)
function sign(double) returns double
sin
Compute the sine of the input expression (as radians). Supported Signatures
function sin(double) returns double
sinh
Compute the hyperbolic sine of the input expression. Supported Signatures
function sinh(double) returns double
sqrt
Compute the square root of the input expression. Supported Signatures
function sqrt(double) returns double
square
Compute the square of the input expression. Supported Signatures
function square(double) returns double
tan
Compute the tangent of the input expression (as radians). Supported Signatures
function tan(double) returns double
tanh
Compute the hyperbolic tangent of the input expression (as radians). Supported Signatures
function tanh(double) returns double
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
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)