* Karam Chand
[...]
> > > Is there any way wherein I can get data like
> > > .01,
> > > .02 etc.
* Roger Baklund
> > Maybe the FORMAT() function will do what you want:
* Karam Chand
> It formats the output to ##,###,##.## . I dont want
> the commas and also I dont know what maximum decima
Hello
It formats the output to ##,###,##.## . I dont want
the commas and also I dont know what maximum decimal
value is there in the table. It may be .001 or it
maybe .001 . I just want them in simple expanded
form.
karam
--- Roger Baklund <[EMAIL PROTECTED]> wrote:
> * Karam Chand
> > I ha
* Karam Chand
> I have a column with double values like -
>
> .01
> .02
> .03
>
> Well...its sounds ridiculous but i do have data like
> that :)
>
> I am using C API to get the resultset, but the data is
> resturned as ( also with mysql client which uses C API
> ).
>
> |1e-006
Greetings
I have a column with double values like -
.01
.02
.03
Well...its sounds ridiculous but i do have data like
that :)
I am using C API to get the resultset, but the data is
resturned as ( also with mysql client which uses C API
).
|1e-006 |
|2e-006 |
|3e-006 |
|