http://qs321.pair.com?node_id=1145106


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"

[download]
you state: 
      I get 1679971.000

[download]
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

In Section Seekers of Perl Wisdom