[socal-piggies] Reminder: meeting this Thursday 01/18 at USC 7 PM

[Chris Hughes]

Is it a decimal field type?
If it is make sure that its represented as such.

OR

In your select do
select field1, field2, format(field3,2) as field3 from whereever
If that isn't suitable use the round function instead.

-C

On 1/19/07, Joshua Gauthier <jjgauthi at gmail.com> wrote:
> Greetings everyone,
>
> I have a quck question, I am running a query out of mysql and dumping it to
> txt, but I am experiencing some formatting issues, I would prefer my query
> to just dump a raw number instead of something similar to this:
>
> ((54948.899902343997,),)
>
> any sage advice you can give would be greatly appreciated.
>
> Thanks
>
> Josh
>
> _______________________________________________
> socal-piggies mailing list
> socal-piggies at lists.idyll.org
> http://lists.idyll.org/listinfo/socal-piggies
>
>
>