To convert numbers to words, for example 1 to first, 2 to second etc.
SQL> SELECT TO_CHAR(TO_DATE(1, 'J'),'JSPTH') FROM dual;
TO_CH
-----
FIRST
SQL> SELECT TO_CHAR(TO_DATE(2, 'J'),'JSPTH') FROM dual;
TO_CHA
------
SECOND
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment