abs
Returns the absolute value of x.
Examples:
Supported Signatures
function abs(tinyint) returns tinyint
function abs(smallint) returns smallint
function abs(bigint) returns bigint
function abs(double) returns double
function abs(decimal(p, s)) returns decimal(p, s)
function abs(real) returns real
🔗 Official Documentation
acos
Returns the arc cosine of x.
Examples:
select acos(0.5) as value;
Supported Signatures
function acos(double) returns double
🔗 Official Documentation
asin
Returns the arc sine of x.
Examples:
Supported Signatures
function asin(double) returns double
🔗 Official Documentation
atan
Returns the arc tangent of x.
Examples:
Supported Signatures
function atan(double) returns double
🔗 Official Documentation
atan2
Returns the arc tangent of y / x.
Examples:
select atan2(1, 0.5) as value;
Supported Signatures
function atan2(double, double) returns double
🔗 Official Documentation
cbrt
Returns the cube root of x.
Examples:
SELECT cbrt(328509) as value;
Supported Signatures
function cbrt(double) returns double
🔗 Official Documentation
ceil
This is an alias for ceiling().
Examples:
SELECT ceil(1.3) AS value;
Supported Signatures
function ceil(bigint) returns bigint
function ceil(double) returns double
function ceil(real) returns real
🔗 Official Documentation
ceiling
Returns x rounded up to the nearest integer.
Supported Signatures
function ceiling(bigint) returns bigint
function ceiling(double) returns double
function ceiling(real) returns real
🔗 Official Documentation
cos
Returns the cosine of x.
Examples:
select cos(1.0) as value;
Supported Signatures
function cos(double) returns double
🔗 Official Documentation
cosh
Returns the hyperbolic cosine of the given value.
Examples:
Supported Signatures
function cosh(double) returns double
🔗 Official Documentation
degrees
Converts angle x in radians to degrees.
Examples:
SELECT degrees(3.14159) AS value;
Supported Signatures
function degrees(double) returns double
🔗 Official Documentation
exp
Returns Euler’s number raised to the power of x.
Examples:
select exp(1.0) as value;
Supported Signatures
function exp(double) returns double
🔗 Official Documentation
floor
Returns x rounded down to the nearest integer.
Supported Signatures
function floor(bigint) returns bigint
function floor(double) returns double
🔗 Official Documentation
is_nan
Determine if x is not-a-number.
Examples:
select is_nan(1.1) as value;
Supported Signatures
function is_nan(double) returns boolean
function is_nan(real) returns boolean
🔗 Official Documentation
Returns the natural logarithm of x.
Examples:
Supported Signatures
function ln(double) returns double
🔗 Official Documentation
log
Returns the base b logarithm of x.
Examples:
SELECT log(2.19, 1) AS value;
Supported Signatures
function log(double, double) returns double
🔗 Official Documentation
log10
Returns the base 10 logarithm of x.
Examples:
select log10(10) as value;
Supported Signatures
function log10(double) returns double
🔗 Official Documentation
log2
Returns the base 2 logarithm of x.
Examples:
Supported Signatures
function log2(double) returns double
🔗 Official Documentation
mod
Returns the modulus (remainder) of n divided by m.
Supported Signatures
function mod(bigint, bigint) returns bigint
function mod(double, double) returns double
🔗 Official Documentation
Returns the constant Pi.
Examples:
Supported Signatures
function pi() returns double
🔗 Official Documentation
pow
This is an alias for power().
Supported Signatures
function pow(double, double) returns double
🔗 Official Documentation
power
Returns x raised to the power of p.
Examples:
select power(2, 8) as value;
Supported Signatures
function power(double, double) returns double
🔗 Official Documentation
radians
Converts angle x in degrees to radians.
Examples:
SELECT radians(360) AS value;
Supported Signatures
function radians(double) returns double
🔗 Official Documentation
rand
This is an alias for random().
Supported Signatures
function rand() returns double
Note: rand() is volatile, i.e. might return a
different value for the same input.
🔗 Official Documentation
random
Returns a pseudo-random value in the range 0.0 <= x < 1.0.
Examples:
select random() as value;
Supported Signatures
function random() returns double
Note: random() is volatile, i.e. might return a
different value for the same input.
🔗 Official Documentation
round
Returns x rounded to the nearest integer.
Examples:
select round(2.1) as value;
Supported Signatures
function round(double) returns double
function round(double, bigint) returns double
function round(real) returns real
function round(real, bigint) returns real
🔗 Official Documentation
sign
Returns the signum function of x, that is.
Supported Signatures
function sign(decimal(p, s)) returns decimal(1, 0)
function sign(double) returns double
function sign(real) returns real
🔗 Official Documentation
sin
Returns the sine of x.
Examples:
select sin(2.1) as value;
Supported Signatures
function sin(double) returns double
🔗 Official Documentation
sinh
Returns the hyperbolic sine of x.
Examples:
Supported Signatures
function sinh(double) returns double
🔗 Official Documentation
sqrt
Returns the square root of x.
Examples:
select sqrt(16) as value;
Supported Signatures
function sqrt(double) returns double
🔗 Official Documentation
tan
Returns the tangent of x.
Examples:
select tan(0.5) as value;
Supported Signatures
function tan(double) returns double
🔗 Official Documentation
tanh
Returns the hyperbolic tangent of x.
Examples:
SELECT tanh(1.0) AS value;
Supported Signatures
function tanh(double) returns double
🔗 Official Documentation
truncate
Returns x rounded to integer by dropping digits after decimal point.
Examples:
SELECT truncate(1.23456, 2) as value;
Supported Signatures
function truncate(decimal(p, s), bigint) returns decimal(p, s)
function truncate(decimal(p, s)) returns decimal(rp, 0)
function truncate(double) returns double
function truncate(real) returns real
🔗 Official Documentation
