<<<<<<< HEAD truncate_value | H2 | SQLDoc
Skip to main content

truncate_value

1. TRUNCATE_VALUE Function

======= truncate_value | H2 Function | SQLDoc

truncate_value

1. TRUNCATE_VALUE Function

>>>>>>> 9d19b1c8cb744c8e86d5c15b74d8b5f719ad62be

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

2. Syntax

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

TRUNCATE_VALUE(value, decimalPlaces)

Arguments

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

Return

  • The TRUNCATE_VALUE function returns the truncated value.

3. Notes

  • The TRUNCATE_VALUE function in H2 database rounds the value towards zero to the specified number of decimal places.
  • If the input value is not a number or exceeds the numeric range, the TRUNCATE_VALUE function will return NULL.
  • Make sure to provide a valid integer value for the decimalPlaces argument. Providing a negative value will result in an error.

4. Examples

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

Example 1 - Truncating a value to 2 decimal places:

SELECT TRUNCATE_VALUE(3.14159, 2) AS truncated_value;

Output:

truncated_value
---------------
3.14

Example 2 - Truncating values stored in a column:

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

INSERT INTO prices VALUES (1, 9.99), (2, 15.75), (3, 24.50);

SELECT id, price, TRUNCATE_VALUE(price, 1) AS truncated_price
FROM prices;

Output:

id | price | truncated_price
---+-------+----------------
1 | 9.99 | 9.9
2 | 15.75 | 15.7
3 | 24.50 | 24.5
  • round - Round a value to a specified number of decimal places.