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