Re: TO_CHAR problems?? Any one can help??

From: <l_davidson_at_my-deja.com>
Date: Tue, 06 Feb 2001 22:09:45 GMT
Message-ID: <95psmv$uvm$1@nnrp1.deja.com>

In article <SMZf6.511$2g.40226_at_newsread2.prod.itd.earthlink.net>, "G" <gennt_at_hotmail.com> wrote:
> Hi all!!!
> Why I am getting four (####) when run this statement:
>
> SELECT TO_CHAR(50,'0V00') FROM DUAL;
> any idea??
>
> Thanks
>
>

You are truncating the result. Try '00V00' as your mask and you should see 5000. Try '000V00' and you will see 05000. The V indicates to return the value multiplied by 10 to the nth power where n is the number of digits following the V.

Sent via Deja.com
http://www.deja.com/ Received on Tue Feb 06 2001 - 16:09:45 CST