RE: TO_CHAR got one space in front

[Amjad Saiyed]

well that space is used 4 the sign bit...   rgds, Ams. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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.