PostgreSQL TRUNC() Function

The PostgreSQL TRUNC() function returns a number truncated to the specified number of decimal places. If decimal_places is a negative number, this function will make digits to the left of the decimal place 0 values.

Syntax

TRUNC(number, decimal_places)

Parameters

Return Value

Returns the truncated value of the number to specified decimal_places.

Example 1:

The example below shows the usage of TRUNC() function.

SELECT TRUNC(1234.5678, 0);
Result: 1234

SELECT TRUNC(1234.5678, 1);
Result: 1234.5

SELECT TRUNC(1234.5678, 2);
Result: 1234.56

SELECT TRUNC(1234.5678, 3);
Result: 1234.567

SELECT TRUNC(1234.5678, -1);
Result: 1230

SELECT TRUNC(1234.5678, -2);
Result: 1200

SELECT TRUNC(1234.5678);
Result: 1234

SELECT TRUNC(-1234.5678);
Result: -1234

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to truncate the records of column x to 2 decimal places.

SELECT *, TRUNC(x, 2) AS TRUNC_Value FROM Sample;

This will produce the result as shown below: