Skip to main content

​
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

​
ln

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

​
pi

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