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