Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

TO_DATE function to convert from characters to dates explicitly

SQL> SQL> SELECT TO_CHAR(LAST_DAY(TO_DATE('23SEP2006','ddMONyyyy'))) FROM dual; TO_CHAR(L --------- 30-SEP-06 SQL>