| 13. 20. TO_CHAR |
| 13. 20. 1. | Formatting Dates with TO_CHAR | | |
| 13. 20. 2. | An alias is required when using TO_CHAR to 'pretty up' the output | | |
| 13. 20. 3. | TO_CHAR(Start_Date, 'dd Month yyyy') | | |
| 13. 20. 4. | TO_CHAR(Start_Date, 'dd month YY') | | |
| 13. 20. 5. | TO_CHAR(Start_Date, 'dd Mon') | | |
| 13. 20. 6. | TO_CHAR(Start_Date, 'dd RM yyyy') | | |
| 13. 20. 7. | TO_CHAR(Start_Date, 'Day Mon yyyy') | | |
| 13. 20. 8. | TO_CHAR(Start_Date, 'Day fmMonth dd, yyyy') | | |
| 13. 20. 9. | TO_CHAR(Start_Date, 'Mon ddsp yyyy') | | |
| 13. 20. 10. | TO_CHAR(Start_Date, 'ddMon yy hh24:mi:ss') | | |
| 13. 20. 11. | TO_CHAR(sysdate,'HH24:MI:SS') | | |
| 13. 20. 12. | select TO_CHAR(sysdate,'HH.MI.SS AM') from dual; | | |
| 13. 20. 13. | to_char(gather_date, 'mm/dd/yyyy hh:mi') | | |