Re: TO_CHAR problems. Can some one help?

From: James Lorenzen -XIOtech Corporation <jlorenzen_at_my-deja.com>
Date: Tue, 06 Feb 2001 21:58:38 GMT
Message-ID: <95ps28$ubm$1_at_nnrp1.deja.com>


The "V" in the mask is the impliced decimal postion, the #### indicates overflow. If you add a leading zero the output is "5000".

HTH
   Jmaes

In article <MNZf6.516$2g.32124_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
>
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Feb 06 2001 - 22:58:38 CET

Original text of this message