Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: OT: Retrieve float number from mysql db

by flexvault (Monsignor)
on Oct 16, 2015 at 12:30 UTC ( #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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1145106]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2020-09-19 03:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    If at first I donít succeed, I Ö










    Results (114 votes). Check out past polls.

    Notices?