Math Functions

`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

SDF DB

Trino Supported Functions

Math Functions

`abs`

`acos`

`asin`

`atan`

`atan2`

`cbrt`

`ceil`

`ceiling`

`cos`

`cosh`

`degrees`

`exp`

`floor`

`is_nan`

`ln`

`log`

`log10`

`log2`

`mod`

`pi`

`pow`

`power`

`radians`

`rand`

`random`

`round`

`sign`

`sin`

`sinh`

`sqrt`

`tan`

`tanh`

`truncate`

​abs

​acos

​asin

​atan

​atan2

​cbrt

​ceil

​ceiling

​cos

​cosh

​degrees

​exp

​floor

​is_nan

​ln

​log

​log10

​log2

​mod

​pi

​pow

​power

​radians

​rand

​random

​round

​sign

​sin

​sinh

​sqrt

​tan

​tanh

​truncate

`abs`

`acos`

`asin`

`atan`

`atan2`

`cbrt`

`ceil`

`ceiling`

`cos`

`cosh`

`degrees`

`exp`

`floor`

`is_nan`

`ln`

`log`

`log10`

`log2`

`mod`

`pi`

`pow`

`power`

`radians`

`rand`

`random`

`round`

`sign`

`sin`

`sinh`

`sqrt`

`tan`

`tanh`

`truncate`