Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

LAST_DAY, TO_CHAR, TO_DATE

SQL> SQL> SELECT TO_CHAR(LAST_DAY(TO_DATE('23SEP2006','ddMONyyyy')), 'Month dd, yyyy') FROM dual; TO_CHAR(LAST_DAY(T ------------------ September 30, 2006 SQL>