It is to remind you that this number to word conversion method was not 100%
work. Sometime it will return wrong result. You can find this old article
from Oracle magaize sample code.
"Stephan Born" <stephan.born_at_beusen.de> wrote in message
news:38D795E7.C2C0E45_at_beusen.de...
> denunez schrieb:
>
> > I NEED TO KNOW HOW CAN I CHANGE DE LANGUAGE OF THE RESULT OF
> > THIS SQL:
> > select to_char(to_date(123,'J'),'jsp') from dual RETURNS
> > one hundred twenty-three
> > I WANT THE RESULT IN ANOTHER LANGUAGE LIKE SPANISH: CIENTO
> > VEINTI TRES
> > WHAT I NEED TO CHANGE ON THE CLIENT OR ON THE SERVER TANK YOU
> >
>
> I thought that this would work....
>
> select to_char(to_date ('123', 'J'), 'jsp', 'NLS_DATE_LANGUAGE=SPANISH')
from
> dual
>
> .. but it returns the english text again....
>
> Regards, Stephan
>
> --
> ---------------------------------------------------------------
> Dipl.-Inf. (FH) Stephan Born | beusen Consulting GmbH
> fon: +49 30 549932-0 | Landsberger Allee 392
> fax: +49 30 549932-21 | 12681 Berlin
> mailto:stephan.born_at_beusen.de | Germany
> ---------------------------------------------------------------
> PGP-Key verfügbar | PGP-Key available
> ---------------------------------------------------------------
>
>
>
>
Received on Thu Mar 23 2000 - 19:49:14 CST
