Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
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
Domain Nodelet?
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 2022-01-18 17:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (53 votes). Check out past polls.

    Notices?