Oracle TRUNC

The Oracle TRUNC function truncates an expression to a number or to a date.
The Oracle TRUNC (number) function returns n1 truncated to n2 decimal places.
The Oracle TRUNC (date) function returns date with the specified format model fmt.

Oracle TRUNC example

select trunc(123.897) from dual;

Result: '123'

select trunc(123.897,0) from dual;

Result: '123'

select trunc(123.897,2) from dual;

Result: '123.89'

select trunc(-123.897,2) from dual;

Result: '-123.89'

select trunc(-123.897,-1) from dual;

Result: '-120'

select trunc(-123.897,-2) from dual;

Result: '-100'

select 
trunc(to_date ('06-NOV-11'),'YEAR') 
from dual;

Result: '1/1/2011'

select 
trunc(to_date ('06-NOV-11'),'Q') 
from dual;

Result: '10/1/2011'