Re: to_char question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 29 Sep 2000 21:32:59 +0100
Message-ID: <970259847.12882.0.nnrp-02.9e984b29@news.demon.co.uk>

The space allows for a minus.
Use 'FM0000'

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Phil R Lawrence wrote in message <8r2q9n$kig_at_fidoii.CC.Lehigh.EDU>...


>Why does:

>    select 'C' || to_char(1,'0000') TEST from dual;

>

>result in:

>    TEST

>    ------

>    C 0001

>

>The issue is the un-asked for space in front of the zeroes!

>

>Thanks,

>Phil R Lawrence

>

>

Received on Fri Sep 29 2000 - 15:32:59 CDT