Re: using to_char
From: Andrew Barnett <nobody_at_spamandeggs.bp.com>
Date: 1998/03/24
Message-ID: <01bd56de$a8a73220$8c0564a1_at_azmelw1358.mel.az.bp.com>#1/1
Date: 1998/03/24
Message-ID: <01bd56de$a8a73220$8c0564a1_at_azmelw1358.mel.az.bp.com>#1/1
the leading space is for the sign
you can also use to_char(1234,'fm00009') to supress leading spaces in to_char conversions of number and date
-- Andrew - Wizzard barnetaj_at_bp.com Vinod Nair <vinod.nair_at_polymerland.com> wrote in article <35170607.1A80_at_polymerland.com>...Received on Tue Mar 24 1998 - 00:00:00 CET
> While using to_char(1234,'00009') for formatting the number , the length
> of the output comes out as 6 , instead of 5 (00009) .The output I want
> is '01234' , but the output generated is ' 01234' .I can use ltrim and
> take away the space , but is there any reason why this should happen ?
>