Re: TO_CHAR got one space in front

2002-08-12 Thread Connor McDonald 

check out the 'fm' format clause

ie to_char(x,'fm');

hth
connor

 --- shuan [EMAIL PROTECTED] wrote:  Hi all,
 
 Have you guys ever try this before:
 
   1* select to_char(1.6,'0.') from dual
 SQL /
 
 TO_CHAR(1.6
 ---
  1.6000
 
 Notice that got one space in front of 1.6000?
 
 I'm using Oracle 8.0.5 in Linux.
 
 Thanks in advance.
  

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

Remember amateurs built the ark - Professionals built the Titanic

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: TO_CHAR got one space in front

2002-08-11 Thread Amjad Saiyed 



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

rgds,
Ams.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of shuanSent: Monday, 
  August 12, 2002 6:53 AMTo: Multiple recipients of list 
  ORACLE-LSubject: TO_CHAR got one space in 
front
  Hi all,
  
  Have you guys ever try this before:
  
   1* select to_char(1.6,'0.') from 
  dualSQL /
  
  TO_CHAR(1.6---1.6000
  
  Notice that got one space in front of 
  "1.6000"?
  
  I'm using Oracle 8.0.5 in Linux.
  
  Thanks in 
advance.