Re: Function needed
From: Charles Jardine <cj10_at_cam.ac.uk>
Date: Fri, 26 Mar 1999 11:23:54 +0000
Message-ID: <36FB6E4A.A8D0DB15_at_cam.ac.uk>
SQL> / TO_CHAR(ADD_MONTHS(TO_DATE('00010101'
THREE THOUSAND FOUR HUNDRED FIFTY-SIX SQL>
Date: Fri, 26 Mar 1999 11:23:54 +0000
Message-ID: <36FB6E4A.A8D0DB15_at_cam.ac.uk>
Ken Halsted wrote:
>
> I was wondering if anyone has a function (they could email me) already built
> to take a number and return a formatted "text" version of the number.
> Example, if given, 3,456 it returns "THREE THOUSAND FOUR HUNDRED FIFTY SIX".
SQL> edit
[Quoted] Wrote file afiedt.buf
[Quoted] 1 select to_char(
2 add_months(
3 to_date('00010101','YYYYMMDD'),
4 ((3456-1)*12)
5 ),
6* 'YYYYSP') from dual
SQL> / TO_CHAR(ADD_MONTHS(TO_DATE('00010101'
THREE THOUSAND FOUR HUNDRED FIFTY-SIX SQL>
-- Charles Jardine - Computing Service, University of Cambridge cj10_at_cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679Received on Fri Mar 26 1999 - 12:23:54 CET