to_char(0,'FM990D99') = "0." instead of "0"
Started by Janning Vygenover 23 years ago2 messagesgeneral
select to_char(1, 'FM990D99');
1
select to_char(0, 'FM990D99');
0.
how to avoid the decimal point in the second query??
kind regards,
janning
Re: to_char(0,'FM990D99') = "0." instead of "0"
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@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz