​
abs

Returns the absolute value of x.

Examples:

examples.sql
select abs(-1) as value; -- value '1.0'

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:

examples.sql
select acos(0.5) as value; -- value '1.0471975511965976'

Supported Signatures

function acos(double) returns double

🔗 Official Documentation

​
asin

Returns the arc sine of x.

Examples:

examples.sql
select asin(1) as value; -- value '1.5707963267948966'

Supported Signatures

function asin(double) returns double

🔗 Official Documentation

​
atan

Returns the arc tangent of x.

Examples:

examples.sql
select atan(0) as value; -- value '0.0'

Supported Signatures

function atan(double) returns double

🔗 Official Documentation

​
atan2

Returns the arc tangent of y / x.

Examples:

examples.sql
select atan2(1, 0.5) as value; -- value '1.1071487177940904'

Supported Signatures

function atan2(double, double) returns double

🔗 Official Documentation

​
cbrt

Returns the cube root of x.

Examples:

examples.sql
SELECT cbrt(328509) as value; -- value '69.0'

Supported Signatures

function cbrt(double) returns double

🔗 Official Documentation

​
ceil

This is an alias for ceiling().

Examples:

examples.sql
SELECT ceil(1.3) AS value; -- value '2.0'

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:

examples.sql
select cos(1.0) as value; -- value '0.5403023058681398'

Supported Signatures

function cos(double) returns double

🔗 Official Documentation

​
cosh

Returns the hyperbolic cosine of the given value.

Examples:

examples.sql
SELECT cosh(0) AS value; -- value '1.0'

Supported Signatures

function cosh(double) returns double

🔗 Official Documentation

​
degrees

Converts angle x in radians to degrees.

Examples:

examples.sql
SELECT degrees(3.14159) AS value; -- value '179.9998547447946'

Supported Signatures

function degrees(double) returns double

🔗 Official Documentation

​
exp

Returns Euler’s number raised to the power of x.

Examples:

examples.sql
select exp(1.0) as value; -- value '2.718281828459045'

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:

examples.sql
select is_nan(1.1) as value; -- value 'false'

Supported Signatures

function is_nan(double) returns boolean
function is_nan(real) returns boolean

🔗 Official Documentation

​
ln

Returns the natural logarithm of x.

Examples:

examples.sql
select ln(2.1) as value; -- value '0.7419373447293773'

Supported Signatures

function ln(double) returns double

🔗 Official Documentation

​
log

Returns the base b logarithm of x.

Examples:

examples.sql
SELECT log(2.19, 1) AS value; -- value '0.0'

Supported Signatures

function log(double, double) returns double

🔗 Official Documentation

​
log10

Returns the base 10 logarithm of x.

Examples:

examples.sql
select log10(10) as value; -- value '1.0'

Supported Signatures

function log10(double) returns double

🔗 Official Documentation

​
log2

Returns the base 2 logarithm of x.

Examples:

examples.sql
select log2(2) as value; -- value '1.0'

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

​
pi

Returns the constant Pi.

Examples:

examples.sql
SELECT PI() -- value '3.141592653589793'

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:

examples.sql
select power(2, 8) as value; -- value '256'

Supported Signatures

function power(double, double) returns double

🔗 Official Documentation

​
radians

Converts angle x in degrees to radians.

Examples:

examples.sql
SELECT radians(360) AS value; -- value '6.283185307179586'

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:

examples.sql
select random() as value; -- value '0.8781138533805801'

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:

examples.sql
select round(2.1) as value; -- value '2.0'

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:

examples.sql
select sin(2.1) as value; -- value '-0.8632093666488737'

Supported Signatures

function sin(double) returns double

🔗 Official Documentation

​
sinh

Returns the hyperbolic sine of x.

Examples:

examples.sql
SELECT sinh(1) AS value; -- value '1.1752011936438014'

Supported Signatures

function sinh(double) returns double

🔗 Official Documentation

​
sqrt

Returns the square root of x.

Examples:

examples.sql
select sqrt(16) as value; -- value '4.0'

Supported Signatures

function sqrt(double) returns double

🔗 Official Documentation

​
tan

Returns the tangent of x.

Examples:

examples.sql
select tan(0.5) as value; -- value '0.5463024898437905'

Supported Signatures

function tan(double) returns double

🔗 Official Documentation

​
tanh

Returns the hyperbolic tangent of x.

Examples:

examples.sql
SELECT tanh(1.0) AS value; -- value '0.7615941559557649'

Supported Signatures

function tanh(double) returns double

🔗 Official Documentation

​
truncate

Returns x rounded to integer by dropping digits after decimal point.

Examples:

examples.sql
SELECT truncate(1.23456, 2) as value; -- value '1.23'

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

String FunctionsDatetime Functions