Обсуждение: to_char(0,'FM990D99') = "0." instead of "0"

Поиск
Список
Период
Сортировка

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

От
Janning Vygen
Дата:
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"

От
Karel Zak
Дата:
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