Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Change the original date format in the TO_CHAR function

SQL> SQL> -- Change the original date format in the TO_CHAR function 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>