Re: number format (.5 instead of 0.5)

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Tue, 24 Sep 2002 09:28:10 GMT
Message-ID: <20020924.9281053@mis.configured.host>

Hello Tino,

maybe with is you're looking for:
select to_char(0.5,'0D0') from dual

bye
Ralf

>>>>>>>>>>>>>>>>>> Ursprüngliche Nachricht <<<<<<<<<<<<<<<<<<

Am 24.09.2002, 11:08:44, schrieb Tino Korth <newsgroup_at_tk79.de> zum Thema number format (.5 instead of 0.5):

> Hello,

> I've got a float field with the value ".5" (I've insertet a "0.5"-value,
> but Oracle formats the value to ".5").
> How can I "re"format the float when I'm SELECTing this value? I wanna
> have "0.5" as a return value.

> Greetings from Rostock, Germany!

> Tino

> --
> Tino Korth Registered Linux User #286417
> www.tinokorth.de - ICQ 10771191 http://counter.li.org
Received on Tue Sep 24 2002 - 04:28:10 CDT