Oracle/PLSQL: Trunc Function (with numbers)
In Oracle/PLSQL, the trunc function returns a number truncated to a certain number of decimal places.
Syntax
The syntax for the trunc function is:
trunc( number, [ decimal_places ] )
number is the number to truncate.
decimal_places is 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.
Applies To
- Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
For Example
| trunc(125.815) | would return 125 |
| trunc(125.815, 0) | would return 125 |
| trunc(125.815, 1) | would return 125.8 |
| trunc(125.815, 2) | would return 125.81 |
| trunc(125.815, 3) | would return 125.815 |
| trunc(-125.815, 2) | would return -125.81 |
| trunc(125.815, -1) | would return 120 |
| trunc(125.815, -2) | would return 100 |
| trunc(125.815, -3) | would return 0 |