Trunc Function (Number) Oracle

Trunc function truncates number to specified decimals

Synatx :

TRUNC(m,[n]) – Truncates to n decimal. n is optional

Examples:-

SQL> select trunc(25.48,1) from dual;

TRUNC(25.48,1)
————–
25.4

SQL> select trunc(25.4,1) from dual;

TRUNC(25.4,1)
————-
25.4

SQL> select trunc(25.6,1) from dual;

TRUNC(25.6,1)
————-
25.6

some more ….

trunc(25.6,-1) returns 20
trunc(25.6,0) returns 25
trunc(25.65,1) returns 25.6
trunc(25.45,0) returns 25

Author: sqlandplsql

To learn more about the Oracle, SQL, PL SQL, Performance Tuning, Database Modeling, Ubuntu, MySQL etc .Suggestions, comments, feedbacks and referrals are highly appreciated. View all posts by sqlandplsql