Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: TO_CHAR problems?? Any one can help??

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

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Tue, 06 Feb 2001 21:11:21 GMT
Message-ID: <ZLZf6.56$So3.3166@skycache.prestige.net> 






The result is too big for the format you asked for. Try '00V00' instead.



"G" <gennt_at_hotmail.com> wrote in message
news:SMZf6.511$2g.40226_at_newsread2.prod.itd.earthlink.net...


> Hi all!!!

> Why I am getting four (####) when run this statement:

>

> SELECT TO_CHAR(50,'0V00') FROM DUAL;


>  any idea??

>

> Thanks

>

>

Received on Tue Feb 06 2001 - 15:11:21 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US