|
| |
| 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' | | |
|