round [Oracle SQL]

round(n)
round(n, precision)

select round( 7.7777),
       round( 7.7777, 3),
       round( 3.3333, 2),
       round(-3.3333, 2),
       round(-7.7777, 1)
  from dual;

ROUND(7.7777) ROUND(7.7777,3) ROUND(3.3333,2) ROUND(-3.3333,2) ROUND(-7.7777,1)
------------- --------------- --------------- ---------------- ----------------
            8           7.778            3.33            -3.33             -7.8

round(d)
round(d, 'format-string')

select round(date '2006-04-03'),
       round(date '2006-04-03', 'month'),
       round(date '2006-04-03', 'year')
  from dual;

ROUND(DAT ROUND(DAT ROUND(DAT
--------- --------- ---------
03-APR-06 01-APR-06 01-JAN-06