Article View: comp.databases.oracle.tools
Article #6Re: to_char(123, '999999') problem
From: Connor McDonald
Date: Tue, 02 May 2000 00:00
Date: Tue, 02 May 2000 00:00
34 lines
1653 bytes
1653 bytes
Mike Morgan wrote: > > When a number is converted to text, a leading space is left in case the > number is negative (eg: to_char(-123,'99999')). If you don't want a > leading space, you'll have to ltrim(to_char(123, '999999')). > > Mike > ================================ > > Marcos Leija <marcos.leija@cas-mddc.com> wrote in message > news:390E051A.6CF86E98@cas-mddc.com... > > How do I get rid of the leading space that to_char() creates when I set > > it up like this: > > to_char(123, '999999') > > returns ' 123' > > > > > > In actuality, I need to_char() to do this: > > to_char(123, '099999') > > ...but it does the same thing. > > > > Is this a bug or is this some setting I left out? > > Marcos > > Or use the FM format mask. HTH -- =========================================== Connor McDonald http://www.oracledba.co.uk We are born naked, wet and hungry...then things get worse
Technical Details
Message-ID:
<390EC9CE.1BFD@yahoo.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<390E051A.6CF86E98@cas-mddc.com> <rKpP4.46$do2.99058@ratbert.tds.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 11355a,9d34cd84934db462 X-Google-Attributes: gid11355a,public X-Google-Thread: f5464,9d34cd84934db462 X-Google-Attributes: gidf5464,public From: Connor McDonald <connor_mcdonald@yahoo.com> Subject: Re: to_char(123, '999999') problem Date: 2000/05/02 Message-ID: <390EC9CE.1BFD@yahoo.com> X-Deja-AN: 618385872 Content-Transfer-Encoding: 7bit References: <390E051A.6CF86E98@cas-mddc.com> <rKpP4.46$do2.99058@ratbert.tds.net> To: Mike Morgan <mmorgan1@mail.tds.net> Content-Type: text/plain; charset=us-ascii Organization: BT Internet Mime-Version: 1.0 Reply-To: connor_mcdonald@yahoo.com Newsgroups: comp.databases.oracle.tools,bit.listserv.sqlinfo