TO_CHAR got one space in front

From: shuan <shuan.tay_at_pci.co.id>
Date: Sun, 11 Aug 2002 18:53:18 -0800
Message-ID: <F001.004B19A6.20020811185318@fatcity.com>

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: shuan
  INET: shuan.tay_at_pci.co.id

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 Sun Aug 11 2002 - 21:53:18 CDT