Numeric Functions

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