using to_char

From: Vinod Nair <vinod.nair_at_polymerland.com>
Date: 1998/03/23
Message-ID: <35170607.1A80_at_polymerland.com>#1/1

[Quoted] [Quoted] While using to_char(1234,'00009') for formatting the number , the length [Quoted] 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 ? Received on Mon Mar 23 1998 - 00:00:00 CET

This message: [ Message body ]
Next message: phil.webb_at_health.wa.gov.au: "Web Forms"
Previous message: Joe Strano: "Re: Tabs: Use Forms 4.5 or upgrade to 5.0?"
Next in thread: Mabel Triguis: "Re: using to_char"
Reply: Andrew Barnett: "Re: using to_char"
Reply: Nicolas Issakides: "Re: using to_char"
Reply: Mabel Triguis: "Re: using to_char"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message