Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: to_char question
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