SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 34

Example:
SELECT TO_CHAR(-10000,'L99G999D99MI')
"Result"
FROM DUAL;
Output:
Result
--------------
$10,000.00-
Example:
SELECT TO_DATE('January 15, 1989, 11:00 A.M.',
'Month dd, YYYY, HH:MI A.M.',
'NLS_DATE_LANGUAGE = American')
FROM DUAL;
Example:
SELECT TO_NUMBER('$10,000.00-',
'L99G999D99MI') "Result"
FROM DUAL;
Output:
Result
---------
-1000