Thursday, January 3, 2008

Convert numbers to words(positional)

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

No comments:

Google