The value 109.29 was truncated to the single digit on the left side of the decimal point : TRUNC « Numeric Math Functions « Oracle PL / SQL






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

The value 109.29 was truncated to the single digit on the left side of the decimal point

 
SQL>
SQL> SELECT
  2     TRUNC(109.29, -1) truncated








Related examples in the same category

1.TRUNC(x [, y]) Returns the result of truncating x an optional y decimal places
2.TRUNC() returns its argument truncated to the number of decimal places specified with the second argument.
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