Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. 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>