CODEWITHSUNDEEP
mysqlfloating-pointformatdecimal
richardnixonthethird
richardnixonthethird

Reputation: 345

Formatting Decimals in MySQL without the leading 0

Is there any way to store the float value .999 instead of 0.999 in MySQL(ie. is there a way to get rid of the zero in front of the decimal)

Upvotes: 0

Views: 754

Answers (1)

Dave Starling
Dave Starling

Reputation: 66

Unless you store it as a string, no. If you want to display it like that, then use your language of choice to format it.

Upvotes: 1

Related Questions