Re: Translation Number to full text

Try this.

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

Al

On 21 Jul 2003 00:45:27 -0700, hay_tray_at_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
Received on Mon Jul 21 2003 - 08:02:32 CDT