Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Leading 0 for float numbers between 0 and 1

Leading 0 for float numbers between 0 and 1

From: <falbrech_www_at_gmx.de>
Date: 23 Feb 2006 02:59:04 -0800
Message-ID: <1140692344.571781.103900@p10g2000cwp.googlegroups.com>


Hello,

is there a way to retrieve floats between 0 and 1 with an 0 before the decimal point, e.g. .12 -> 0.12? But a value like 1234.34345 shold be displayed as is.

Actually a solution which influcences any statements without changing them would be preferable (changing a session parameter for example).

thanks in advance,
Florian Received on Thu Feb 23 2006 - 04:59:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US