Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

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