Re: I need help with TO_CHAR function. Can any one help?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 7 Feb 2001 13:08:51 +0100
Message-ID: <t82einf5ea5e48_at_beta-news.demon.nl>

From the manual
V
 999V99
[Quoted]  Returns a value multiplied by 10n (and if necessary, round it up), where n [Quoted] is the number of 9's after the "V".

so
[Quoted]   1* select to_char(50,'99V99') tc from dual SQL> / TC

---

 5000
is correct and conformance with the description. The result of the your mask is a string of length 4, as that doesn't fit it returns 4 #.
[Quoted] [Quoted] This is expected behavior NOT a bug.

Hth,

Sybrand Bakker, Oracle DBA

"G" <gennt_at_hotmail.com> wrote in message news:mJag6.7760$iM6.955632_at_newsread1.prod.itd.earthlink.net...
> Hello all.
> Why I am getting four (####), instead of getting only three(###), when run
> this statement:
>
> SELECT TO_CHAR(50,'0V00') FROM DUAL;
> In my opinion it should show me 3(###) signs or I am wrong. Any one can
 help
> me or lead me why is this happening. I think it's a bug with TO_CHAR
> function.
>
> Thanks for your help
>
>
>
Received on Wed Feb 07 2001 - 13:08:51 CET