Re: Function needed

From: Charles Jardine <cj10_at_cam.ac.uk>
Date: Fri, 26 Mar 1999 11:53:53 +0000
Message-ID: <36FB7551.42BA1ABD_at_cam.ac.uk>

Charles Jardine wrote:
>
> SQL> edit
> Wrote file afiedt.buf
>
> 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>
Better is:

  1* select to_char(to_date('1','J') + (5373484 - 1), 'JSP') from dual SQL> /   TO_CHAR(TO_DATE('1','J')+(5373484-1),'JSP')

---

FIVE MILLION THREE HUNDRED SEVENTY-THREE THOUSAND FOUR HUNDRED EIGHTY-FOUR   [Quoted] This is the largest number that this method can handle.

-- 
[Quoted] Charles Jardine - Computing Service, University of Cambridge
cj10_at_cam.ac.uk    Tel: +44 1223 334506, Fax: +44 1223 334679

Received on Fri Mar 26 1999 - 12:53:53 CET