Skip to main content

round

1. ROUND Function​

The ROUND function in H2 database is used to round a numeric value to a specified number of decimal places.

2. Syntax​

The syntax for the ROUND function in H2 database is as follows:

ROUND(value, decimal_places)

Arguments​

  • value: The numeric value that needs to be rounded.
  • decimal_places: The number of decimal places to which the value should be rounded. It should be an integer value.

Return​

  • The ROUND function returns the rounded value.

3. Notes​

  • The ROUND function in H2 database performs rounding according to the standard rounding rules. If the decimal part is exactly halfway between two possible rounded values, the result is rounded to the nearest even number.
  • If the input value or decimal_places is not a number or exceeds the numeric range, the ROUND function will return NULL.
  • Be cautious while rounding very large or very small values, as precision loss can occur.

4. Examples​

Here are a few examples demonstrating the usage of the ROUND function in H2 database:

Example 1 - Rounding a value to 2 decimal places:​

SELECT ROUND(3.14159, 2) AS rounded_value;

Output:

rounded_value
-------------
3.14

Example 2 - Rounding a column of values:​

CREATE TABLE prices (
  id INT PRIMARY KEY,
  price DECIMAL(10, 2)
);

INSERT INTO prices VALUES (1, 9.99), (2, 19.99), (3, 24.49);

SELECT id, price, ROUND(price, 1) AS rounded_price
FROM prices;

Output:

id | price | rounded_price
---+-------+---------------
1  | 9.99  | 10.0
2  | 19.99 | 20.0
3  | 24.49 | 24.5
  • CEILING - Round up to the nearest integer
  • floor - Round down to the nearest integer