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 -> Re: Function TO_CHAR

Re: Function TO_CHAR

From: Tigran <spider_at_menq.am>
Date: 4 Nov 2004 06:53:11 -0800
Message-ID: <b9883b44.0411040653.2e778338@posting.google.com> 





"Petr Benes" <benes_at_epos.cd.cz> wrote in message news:<4189e1f4.0_at_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




Use 


to_char(15, 'FM0999')
Received on Thu Nov 04 2004 - 08:53:11 CST












Original text of this message













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