Monday, 23 April 2007

Number to Words

A neat trick to convert a number to the same number in words ( 12 becomes twelve ).

select n, to_char(date '-4712-01-01' + (n-1),'jspth')
from (select 1721058 n from dual);


Try it out and play with the NLS LANG settings for different results.

No comments: