Numbers

ROUND

Rounds a number to an integer or to the number of decimal places you need.

Syntax

ROUND(<number>)
ROUND(<number>, <decimals>)

Without the second argument it rounds to an integer; with it — to the given number of digits after the decimal point. A negative number of places rounds to the left of the point: to tens, hundreds, thousands.

Data for the examples

orders

id	created_at	amount
1	2026-07-03 10:15:00	120.50
2	2026-07-28 18:40:00	80.25
3	2026-08-09 09:05:00	199.99
4	2026-08-21 14:30:00	45.00
5	2026-09-02 11:00:00	64.75

These tables already exist in the sandbox — the examples below use them. Want to try this in your own database? Copy the SQL.

To hundredths, to an integer and to hundreds

SELECT ROUND(19.857, 2) AS two_decimals,

ROUND(19.857) AS to_integer,

ROUND(1234.5, -2) AS to_hundreds;

two_decimals	to_integer	to_hundreds
19.86	20	1200

The average order value with two decimals

SELECT AVG(amount) AS average,

ROUND(AVG(amount), 2) AS rounded

FROM orders;

average	rounded
102.0980000000000000	102.10

One half — two different results

SELECT ROUND(2.5) AS numeric_half,

ROUND(2.5::float8) AS float_half,

ROUND(3.5::float8) AS float_half_2;

numeric_half	float_half	float_half_2
3	2	4

For numeric, a half rounds away from zero; for double precision, to the nearest even number.

Watch out

ROUND(x, 2) exists only for the numeric type. If x is double precision (say, an average of a real column), you'll get function round(double precision, integer) does not exist. The fix is to cast: ROUND(x::numeric, 2).

For double precision, halves round to the nearest even number: ROUND(2.5::float8) gives 2, and ROUND(3.5::float8) gives 4. Use numeric for money.

Related functions

CEIL FLOOR TRUNC

Learn more in the course

Numbers and rounding