Rounds May 25, 2005, to the first day in the nearest month
SQL> SQL> SELECT ROUND(TO_DATE('25-MAY-2005'), 'MM') FROM dual; ROUND(TO_ --------- 01-JUN-05 SQL> SQL>