With the function TO_CHAR, I can transform a date on a full text
depending on the NLS-Language.
Is it possible to do the same with a number?
eg : 20 gives twenty, 200 gives two hundred...

thanks for your answers

,philippe <hay_tray@yahoo.fr> wrote:
: With the function TO_CHAR, I can transform a date on a full text
: depending on the NLS-Language.
: Is it possible to do the same with a number?
: eg : 20 gives twenty, 200 gives two hundred...

: thanks for your answers

http://asktom.oracle.com/~tkyte/Misc/SpellANumber.html

Helen

Try this.

select to_char(to_date(54321, 'J'), 'JSP') from dual;

Al



On 21 Jul 2003 00:45:27 -0700, hay_tray@yahoo.fr (philippe) wrote:

>With the function TO_CHAR, I can transform a date on a full text
>depending on the NLS-Language.
>Is it possible to do the same with a number?
>eg : 20 gives twenty, 200 gives two hundred...
>
>thanks for your answers

,philippe <hay_tray@yahoo.fr> wrote:
: Thanks Helen

: but is it possible to get it in Spanish or an other language?

: if I wrote
: select to_char(to_date('15','J'),'Jsp','NLS_DATE_LANGUAGE = SPANISH') from
dual;

: I get
: Fifteen
: and I want to get
: Quince

Take a look at:

http://asktom.oracle.com/pls/ask/f?p...:NO::F4950_P8_
DISPLAYID,F4950_P8_CRITERIA:1407603857650,

This line will wrap and need to be joined back up.

HTH Helen

/\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\
( oo ) ( oo ) ( oo ) ( oo ) ( oo ) ( ** ) ( oo ) ( oo ) ( oo ) ( oo ) ( oo )
=^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^=

Thanks a lot, very good

Philippe