Round Function Examples

Example Round numbers

select round(123.256) from dual;
Result: '123'
select round(123.256,0) from dual;
Result: '123'
select round(123.256,2) from dual;
Result: '123.26'



Example Round dates

select round(to_date ('06-NOV-11'),'YEAR') from dual;
Result: '1/1/2012'
select round(to_date ('06-NOV-11'),'Q') from dual;
Result: '10/1/2011'
select round(to_date ('06-NOV-11'),'MONTH') from dual;
Result: '11/1/2011'