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: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 4 Nov 2004 05:23:19 -0500
Message-ID: <KIWdnfCYK8GGnhfcRVn-3w@comcast.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

|

|




for the negative sign (strongly suggest reading the SQL manual, look under
'Number Format Elements')



++ mcs
Received on Thu Nov 04 2004 - 04:23:19 CST












Original text of this message













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