Re: SQL Number to Text Conversion

[Quoted] works fine for numbers between ...

ORA-01854: julian date must be between 1 and 5373484

Erika Grondzakova wrote:

> 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 Fri Jan 28 2000 - 12:16:24 CET