Syntax: ROUND(, [])
SQL> SQL> SQL> SELECT 2 ROUND(SYSDATE, 'MONTH') near_month, 3 SYSDATE today 4 FROM DUAL; NEAR_MONT TODAY --------- --------- 01-JUL-08 20-JUN-08 SQL>