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

Home -> Community -> Usenet -> c.d.o.server -> Function TO_CHAR

Function TO_CHAR

From: Petr Benes <benes_at_epos.cd.cz>
Date: Thu, 4 Nov 2004 09:01:55 +0100
Message-ID: <4189e1f4.0@10.140.56.22> 





Hi



Expression TO_CHAR(15) returns '15'. It is correct.
Expression TO_CHAR(15,'0999') returns ' 0015' instead '0015'.
Tested in version 10q as well as 7.3.4.



Do you know why there is the blankspace?



Thanks
Received on Thu Nov 04 2004 - 02:01:55 CST












Original text of this message













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