PostgreSQL trunc function.

Preamble

PostgreSQL trunc function returns a number truncated to a certain number of decimal places.

Syntax of the trunc function in PostgreSQL

trunc( number, [ decimal_places ] ) )

Parameters and function arguments

• number – A number for truncation.
• Decimal_places – Optional. The number of decimal places for truncation. This value must be a positive or negative integer number.

Note:

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

The trunc 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 trunc functions to see how to use the trunc function in PostgreSQL.
For example:

SELECT trunc(123.431);

--Result: 123

SELECT trunc(123.652, 0);

--Result: 123

SELECT trunc(123.652, 1);

--Result: 123.6

SELECT trunc(123.652, 2);

--Result: 123.652, 2); -Output: 123.6 SELECT trunc(123.652, 2).

SELECT trunc(123.652, -1); -Output: 123.6 SELECT trunc(123.652, -1);

--Result: 120

SELECT trunc(123.652, -2);

--Result: 100

SELECT trunc(-123.652);

--Result: -123

Date functions in PostgreSQL , Time functions in PostgreSQL

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.