TO_CHAR « Conversion Functions « Oracle PL / SQL
- Oracle PL / SQL
- Conversion Functions
- TO_CHAR
| 1. | The TO_CHAR() function converts the expression into character data. | | |
| 2. | Pass variable into to_char function | | |
| 3. | Use to_char function to init an text value | | |
| 4. | convert a negative number into one with a trailing "minus sign," | | |
| 5. | to_char(bdate,'fmMonth ddth, yyyy') | | |
| 6. | to_char(round(sqrt(sal),2),'9999.99') | | |
| 7. | to_char(sysdate, 'Day', 'nls_date_language=Dutch') | | |
| 8. | to_char(sysdate,'DAY dy Dy') as day, to_char(sysdate,'MONTH mon') as month | | |
| 9. | to_char(sysdate,'hh24:mi:ss') as time | | |
|
| 10. | CONVERSION functions: Print the current date/time as a character string and modifies the format | | |