Re: using to_char

I believe that if you try :

SQL> select to_char(1234,'00009') from dual;

TO_CHA

and if you try :

SQL> select to_char(-1234,'00009') from dual;

TO_CHA

as you can see, same size but ... the space is used for the sign this is the reason

In article <35170607.1A80_at_polymerland.com>, Vinod Nair <vinod.nair_at_polymerland.com> wrote:
>While using to_char(1234,'00009') for formatting the number , the length
>of the output comes out as 6 , instead of 5 (00009) .The output I want
>is '01234' , but the output generated is ' 01234' .I can use ltrim and
>take away the space , but is there any reason why this should happen ?

Nicolas

Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member

The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Tue Mar 24 1998 - 00:00:00 CET