Re: Urgent Help

From: C. Ferguson <c_ferguson_at_rationalconcepts.com>
Date: 2000/03/12
Message-ID: <38CB0B2E.623F569D@rationalconcepts.com>#1/1

Hi Sarah,
found something interesting in the date formatting, number formatting section of the docs. Using the date format for this purposes will more than likely have limitations, but for 100 and 150, it worked.

so,

select to_char(to_date('100', 'SSSSS'), 'SSSSSSP') from dual;

taking advantage of the date format element SSSSS (Seconds past midnight (0-86399)), and the SSSSS + SP where SP is the date format suffix meaning spelled number.

As you can see, due to the seconds pas midnight range, that will be your limitation...

regards,
cindy

Sarah wrote:

> How can I convert number to character in Oracle.
> Ex.
> select comm from emp;
> Output
> comm
> ----
> 100
> 150
>
> Now I want to output as
> Comm
> ----
> One Hundred
> One Hundred and Fifty
>
> I tried with these
> Select to_char(comm) from emp;
> but this is gone in vain.
>
> Thanks
> Sarah
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
Received on Sun Mar 12 2000 - 00:00:00 CST