Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Round date to day

SQL> SQL> SELECT ROUND(TO_DATE('25-OCT-2005'), 'DD') FROM dual; ROUND(TO_ --------- 25-OCT-05