PostgreSQL round function

Preamble

PostgreSQL round function returns a number rounded to a certain number of decimal places.

Syntax of the round function in PostgreSQL

round( number, [ decimal_places_id ] ) )

Parameters and function arguments

• number – A number for rounding.
• decimal_places_id – The number of decimal digits to which the number is rounded. This value must be a positive or negative integer number. If this parameter is not specified, the rounding function rounds the number to 0 decimals.

Note:

• If decimal_places is a negative number, the round function will make the digits to the left of the decimal digit 0.

The round function can be used in the following PostgreSQL versions

PostgreSQL 11, PostgreSQL 10, PostgreSQL 9.6, PostgreSQL 9.5, PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4.

Let’s look at some examples of the round function to see how to use the round function in PostgreSQL.
For example:

SELECT round(123.315);

--Result: 123

SELECT round(125.315, 0);

--Result: 125

SELECT round(125.315, 1);

--Result: 125.3

SELECT round(125.315, 2);

--Result: 125.32

SELECT round(125.315, -1);

--Result: 130

SELECT round(125.315, -2);

--Result: 100

SELECT round(-123.315);

--Result: -123

PostgreSQL: Arithmetic Operators (ROUND)

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.