Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: OT: Retrieve float number from mysql db

by flexvault (Monsignor)
on Oct 16, 2015 at 12:30 UTC ( [id://1145106] : note . print w/replies, xml ) Need Help??


in reply to OT: Retrieve float number from mysql db

Dear Monks,

I know little about 'mysql' but what does the following do:

"SELECT format(filed,3) FROM table WHERE id = 1"
you state:
I get 1679971.000
That looks to me that 'format(filed,3)' is formating the number to 3 decimal places. What happens if you change it to 'format(filed,0)'?

Hope it helps!

Regards...Ed

"Well done is better than well said." - Benjamin Franklin