On Mon, Jul 22, 2002 at 03:39:43PM +0200, Janning Vygen wrote:
> 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
--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz