# PostgreSQL Tutorial: Math Functions

September 26, 2023

Function Description Example Result
ABS Calculate the absolute value of a number ABS(-10) 10
CBRT Calculate the cube root of a number CBRT(8) 2
CEIL Round a number up to the nearest integer, which is greater than or equal to a specified number CEIL(-12.8) -12
CEILING Same as CEIL
DEGREES Convert radians to degrees DEGREES(0.8) 45.83662361
DIV Return the integer quotient of two numeric values DIV(8,3) 2
EXP Return the exponential value in the scientific notation of a number EXP(1) 2.718281828
FLOOR Round a number down to the nearest integer, which is less than or equal to the number FLOOR(10.6) 10
LN Return the natural logarithm of a numeric value LN(3) 1.098612289
LOG Return the base 10 logarithms of a numeric value LOG(1000) 3
LOG Return the logarithm of a numeric value to a specified base LOG(2, 64) 6
MOD Divide the first parameter by the second one and return the remainder MOD(10,4) 2
PI Return the value of PI PI() 3.141592654
POWER Raise a numeric value to the power of a second numeric value POWER(5, 3) 125
ROUND Round a number to the nearest integer or to a specified decimal places ROUND(10.3) 10
SCALE Return the number of decimal digits in the fractional part SCALE(1.234) 3
SIGN Return the sign (positive, negative) of a numeric value SIGN(-1) -1
SQRT Return the square root of a numeric value SQRT(3.0) 1.732050808
TRUNC Truncate a numeric value to a whole number of the specified decimal places TRUNC(12.3) 12
WIDTH_BUCKET Assign values to buckets in an equi-width histogram.
RANDOM Return a random number that ranges from 0 to 1 0.968435665