Change the original date format in the TO_CHAR function : Date Format « Date Timezone « Oracle PL / SQL

1. Oracle PL / SQL
2. Date Timezone
3. Date Format

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>
           
       

Related examples in the same category