Re: SQL Number to Text Conversion

From: Erika Grondzakova <Erika.Grondzakova_at_cern.ch>
Date: Fri, 28 Jan 2000 11:28:40 +0100
Message-ID: <38916F58.E8D54803@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 Fri Jan 28 2000 - 04:28:40 CST