to_char(123, '999999') problem

Article View: comp.databases.oracle.tools

Article #3

Back to comp.databases.oracle.tools Previous Next

From: Marcos Leija
Date: Mon, 01 May 2000 00:00

12 lines
1143 bytes

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

Technical Details

Message-ID: <390E051A.6CF86E98@cas-mddc.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f5464,9d34cd84934db462,start
X-Google-Attributes: gidf5464,public
X-Google-Thread: 11355a,9d34cd84934db462,start
X-Google-Attributes: gid11355a,public
From: Marcos Leija <marcos.leija@cas-mddc.com>
Subject: to_char(123, '999999') problem
Date: 2000/05/01
Message-ID: <390E051A.6CF86E98@cas-mddc.com>
X-Deja-AN: 618026154
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Abuse-Info: Otherwise we will be unable to process your complaint properly
X-Complaints-To: support@usenetserver.com
Organization: WebUseNet Corp  http://www.usenetserver.com - Home of the fastest NNTP servers on the Net.
MIME-Version: 1.0
NNTP-Posting-Date: Mon, 01 May 2000 18:24:15 EDT
Newsgroups: comp.databases.oracle.tools,bit.listserv.sqlinfo