Works only in ENGLISH!
SQL> SELECT TO_CHAR(to_date(2972,'J'), 'JSP')
2 FROM DUAL;
TO_CHAR(TO_DATE(2972,'J'),'JSP')
TWO THOUSAND NINE HUNDRED SEVENTY-TWO
SQL> alter session set nls_language = 'DUTCH';
Sessie is gewijzigd.
SQL> SELECT TO_CHAR(to_date(2972,'J'), 'JSP')
2 FROM DUAL;
TO_CHAR(TO_DATE(2972,'J'),'JSP')
TWO THOUSAND NINE HUNDRED SEVENTY-TWO
SQL>
Erika Grondzakova <Erika.Grondzakova_at_cern.ch> schreef in berichtnieuws
38916F58.E8D54803_at_cern.ch...
> Hi,
>
> SELECT TO_CHAR(to_date(2972,'J'), 'JSP')
> FROM DUAL;
>
> HTH,
>
> Erika
>
> Colin Sheppard wrote:
> >
> > Hello,
> >
> > I was wondering if you can direct me to some ORACLE PL/SQL code/builtin
> > function, or a web site that converts a numeric value into text, and/or
> > vice-versa? For example:
> >
> > '2972'
> >
> > would be
> >
> > 'two thousand nine hundred and seventy two'
> >
> > Thank you for your kind attention and assistance,
> >
> > Cheers,
> >
> > Colin Sheppard,
> > IT Solutions Specialist,
> > Agilent Technologies,
> > Singapore.
Received on Sat Jan 29 2000 - 00:00:00 CST