Oracle-L: RE: TO_CHAR got one space in front

From: Amjad Saiyed <amjad_at_medicomsoft.com>
Date: Sun, 11 Aug 2002 21:23:20 -0800
Message-ID: <F001.004B1AA5.20020811212320@fatcity.com>

well that space is used 4 the sign bit...

rgds,
Ams.
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of shuan   Sent: Monday, August 12, 2002 6:53 AM
  To: Multiple recipients of list ORACLE-L   Subject: TO_CHAR got one space in front

Hi all,

Have you guys ever try this before:

1* select to_char(1.6,'00000.0000') from dual SQL> / TO_CHAR(1.6

00001.6000

Notice that got one space in front of "00001.6000"?

I'm using Oracle 8.0.5 in Linux.

Thanks in advance.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Amjad Saiyed
INET: amjad_at_medicomsoft.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Aug 12 2002 - 00:23:20 CDT