Re: Number Format
From: Neville Sweet <sweet.neville.nj_at_bhp.com.au.no_junk_email>
Date: 9 Sep 1998 04:06:10 GMT
Message-ID: <01bddba7$40586c40$483c1286_at_itwol-pc3963.itwol.bhp.com.au>
Date: 9 Sep 1998 04:06:10 GMT
Message-ID: <01bddba7$40586c40$483c1286_at_itwol-pc3963.itwol.bhp.com.au>
Also consider mask TO_CHAR(your_number, 'FM999.99'), which gives similar results.
> >However, the number of
> >columns is always one more than I request. I assume this may have to do
> >with reserving one space for a + or - sign. Any way to get exactly the
> >number of columns I request?
> Try something like this:
>
> COLUMN number_out FORMAT A6
> SELECT LTRIM(TO_CHAR(your_number,'999.99')) number_out
> FROM your_table;
>
> regards,
>
> Jonathan Gennick
Received on Wed Sep 09 1998 - 06:06:10 CEST