| 1. | Converting DATE to spelled-out character format | | |
| 2. | TO_CHAR(Date, 'Mon') | | |
| 3. | TO_CHAR(Date, 'Month') | | |
| 4. | TO_CHAR(Date, 'YYYY') | | |
| 5. | TO_CHAR(Date, 'MM') | | |
| 6. | TO_CHAR(Date, 'Year') | | |
| 7. | TO_CHAR(Date, 'Day') | | |
| 8. | TO_CHAR(Date, 'DY') | | |
| 9. | TO_CHAR(Date, 'Q') | | |
|
| 10. | TO_CHAR(Date,'DAY MONTH DD, YYYY') | | |
| 11. | TO_CHAR(Date,'fmDay Month fmDD, YYYY'): Embedded spaces can be removed by placing the 'fm' prefix | | |
| 12. | TO_CHAR(Start_Date, 'DD, MM, Mon, Month, YYYY, Year, Day, DY, Q') | | |
| 13. | Suffix 'sp': spell out a numeric value | | |
| 14. | 'th' suffix: add an ordinal ending to a numeric format element | | |
| 15. | The TO_DATE function in where clause | | |
| 16. | Format current system date: 'dd Mon, yyyy hh24:mi:ss' | | |