Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: to_char question

Re: to_char question

From: Kenneth C Stahl <kcstahl_at_atl.mediaone.net>
Date: Sat, 30 Sep 2000 13:20:10 GMT
Message-ID: <39D5E892.AC1959CE@atl.mediaone.net>

Phil R Lawrence wrote:
>
> 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

select 'C' ||ltrim(to_char(1,'0000')) test from dual; Received on Sat Sep 30 2000 - 08:20:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US