| 15.7.TO_CHAR |
| 15.7.1. | Format Parameters |
| 15.7.2. | TO_CHAR(x [, format]) converts x to a string. |
| 15.7.3. | TO_CHAR() will return a string of pound characters (#) if you try and format a number that contains too many digits for the format you have provided. |
| 15.7.4. | Use TO_CHAR() to convert columns containing numbers to strings. |
| 15.7.5. | TO_CHAR(12345.67, '99,999.99') (1) |
| 15.7.6. | TO_CHAR(12345.67, '99999.99') (2) |
| 15.7.7. | TO_CHAR(-12345.67, '99,999.99') (3) |
| 15.7.8. | TO_CHAR(12345.67, '099,999.99') (4) |
| 15.7.9. | TO_CHAR(12345.67, '99,999.9900') |
| 15.7.10. | TO_CHAR(12345.67, '$99,999.99') |
| 15.7.11. | TO_CHAR(0.67, 'B9.99') |
| 15.7.12. | TO_CHAR(12345.67, 'C99,999.99') |
| 15.7.13. | TO_CHAR(12345.67, '99999D99') |
| 15.7.14. | TO_CHAR(12345.67, '99999.99EEEE') |
| 15.7.15. | TO_CHAR(0012345.6700, 'FM99999.99') |
| 15.7.16. | TO_CHAR(12345.67, '99999G99') |
| 15.7.17. | TO_CHAR(12345.67, 'L99,999.99') |
| 15.7.18. | TO_CHAR(-12345.67, '99,999.99MI') |
| 15.7.19. | TO_CHAR(-12345.67, '99,999.99PR') |
| 15.7.20. | TO_CHAR(2007, 'RN') |
| 15.7.21. | TO_CHAR(12345.67, 'TM') |
| 15.7.22. | TO_CHAR(12345.67, 'U99,999.99') |
| 15.7.23. | TO_CHAR(12345.67, '99999V99') |
| 15.7.24. | TO_CHAR(last_ddl_time,'dd-mon-yyyy hh24:mi') |
| 15.7.25. | to_char(sysdate,'hh24:mi:ss') as time |
| 15.7.26. | to_char(to_date('01/01/2006','dd/mm/yyyy'),is on Day') as new_year_2006 |
| 15.7.27. | to_char(sysdate, 'Day', 'nls_date_language=Dutch') |
| 15.7.28. | to_char(sysdate,'DAY dy Dy') |
| 15.7.29. | to_char(sysdate,'MONTH mon') as month |
| 15.7.30. | to_char(bdate,'fmMonth ddth, yyyy') |
| 15.7.31. | use to_char more than once to create long date format |