Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

TRUNC with precision

SQL> SQL> SELECT TRUNC(44.647, 2) AS POSITIVE FROM Dual;   POSITIVE ----------      44.64 SQL>