Monday, November 20, 2006

How To Convert Numbers Into Characters

To Convert Numbers into Text use the following Select Statment
select to_char(to_date(1500,'j'),'jsp') from dual
it will give you the following Result
one thousand five hundred
but you have to take in your consideration that it will not accept
more than 5,373,484
and it will cause an error

No comments: