to_char(0,'FM990D99') = "0." instead of "0"

to_char(0,'FM990D99') = "0." instead of "0"

Post by Karel Z » Fri, 02 Aug 2002 18:18:06




> select to_char(1, 'FM990D99');
> 1
> select to_char(0, 'FM990D99');
> 0.

> how to avoid the decimal point in the second query??

 Don't use FM?

 This is Oracle (8.0.x) example:

 SVRMGR> SELECT to_char(0, '990D99') FROM DUAL;
 TO_CHAR
 -------
   0.00
 1 row selected.
 SVRMGR> SELECT to_char(0, 'FM990D99') FROM DUAL;
 TO_CHAR
 -------
 0.    
 1 row selected.

 Ask Larry Ellison for this feature... :-)

    Karel

--

 http://home.zf.jcu.cz/~zakkr/

 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html