TRUNC() returns its argument truncated to the number of decimal places specified with the second argument. : TRUNC « Numeric Math Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. TRUNC

TRUNC() returns its argument truncated to the number of decimal places specified with the second argument.

 
SQL>
Syntax:TRUNC(<numeric expression>, <decimal_places>)
     TRUNCATE(<numeric_expression>,<decimal_places>))
SQL>
SQL> SELECT TRUNC(109.29, 1) truncated from dual;

 TRUNCATED
----------
     109.2








Related examples in the same category

1.TRUNC(x [, y]) Returns the result of truncating x an optional y decimal places
2.The value 109.29 was truncated to the single digit on the left side of the decimal point
3.TRUNC: Returns the truncated value (removes decimal part of a number, precision adjustable)
4.TRUNC with precision
5.TRUNC(44.647, 0)
6.TRUNC(44.647, -1)
7.TRUNC(Number,1): truncate values from a column
8.TRUNC(Number,-1)
9.select trunc( 12345.67890 )
10.select trunc( 12345.67890, 2 )
11.Use TRUNC in PL/SQL
12.TRUNC Demo