Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Round date to day
SQL>
SQL> SELECT ROUND(TO_DATE('25-OCT-2005'), 'DD') FROM dual;
ROUND(TO_
---------
25-OCT-05