totn Oracle Functions

Oracle / PLSQL: TRUNC Function (with numbers)

This Oracle tutorial explains how to use the Oracle/PLSQL TRUNC function (as it applies to numeric values) with syntax and examples.

Description

The Oracle/PLSQL TRUNC function returns a number truncated to a certain number of decimal places.

Syntax (with numbers)

The syntax for the TRUNC function in Oracle/PLSQL is:

TRUNC( number [, decimal_places] )

Parameters or Arguments

number
The number to truncate.
decimal_places
Optional. The number of decimal places to truncate to. This value must be an integer. If this parameter is omitted, the TRUNC function will truncate the number to 0 decimal places.

Returns

The TRUNC function (as it applies to numbers) returns a numeric value.

Applies To

The TRUNC function can be used in the following versions of Oracle/PLSQL:

  • Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Example (with numbers)

Let's look at some Oracle TRUNC function examples and explore how to use the TRUNC function in Oracle/PLSQL.

For example:

TRUNC(125.815)
Result: 125

TRUNC(125.815, 0)
Result: 125

TRUNC(125.815, 1)
Result: 125.8

TRUNC(125.815, 2)
Result: 125.81

TRUNC(125.815, 3)
Result: 125.815

TRUNC(-125.815, 2)
Result: -125.81

TRUNC(125.815, -1)
Result: 120

TRUNC(125.815, -2)
Result: 100

TRUNC(125.815, -3)
Result: 0