Re: to_char(123, '999999') problem

Article View: comp.databases.oracle.tools

Article #5

Back to comp.databases.oracle.tools Previous Next

From: Martin Dobler
Date: Tue, 02 May 2000 00:00

21 lines
1296 bytes

You can insert the FM element in the the format string.

e.g. to_char(123, 'FM999999')

this returns a value without leading or trailing blanks.

Martin

Marcos Leija wrote:
> 
> 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: <390EA506.B2E4167A@at.siemens.de>

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

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f5464,9d34cd84934db462
X-Google-Attributes: gidf5464,public
X-Google-Thread: 11355a,9d34cd84934db462
X-Google-Attributes: gid11355a,public
From: Martin Dobler <martin.1.dobler@at.siemens.de>
Subject: Re: to_char(123, '999999') problem
Date: 2000/05/02
Message-ID: <390EA506.B2E4167A@at.siemens.de>
X-Deja-AN: 618196069
Content-Transfer-Encoding: 7bit
References: <390E051A.6CF86E98@cas-mddc.com>
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: newsteam@erlm.siemens.de
X-Trace: papyrus.erlm.siemens.de 957260952 20410 162.3.12.175 (2 May 2000 09:49:12 GMT)
Organization: SIEMENS AG
Mime-Version: 1.0
NNTP-Posting-Date: 2 May 2000 09:49:12 GMT
Newsgroups: comp.databases.oracle.tools,bit.listserv.sqlinfo

Reply to Parent Message