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>
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