Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

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>