I have a column showing "number of weeks" the trouble i am having is some of the weeks are not full so i have 14, 9, and 4.333333 weeks
i have tried
type DECIMAL 10,2 and 10, 6 but this is just showing 4.00 or 4.000000
i also tried float and this is showing the same
i need the decimal to show the only value 4.333333
phpMyAdmin need to show decimal
Moderator: General Moderators
-
jonnyfortis
- Forum Contributor
- Posts: 462
- Joined: Tue Jan 10, 2012 6:05 am
-
jonnyfortis
- Forum Contributor
- Posts: 462
- Joined: Tue Jan 10, 2012 6:05 am
Re: phpMyAdmin need to show decimal
i have used VARCHAR and seems to work ok
Re: phpMyAdmin need to show decimal
If you're looking to store a decimal, it makes more sense to use DECIMAL for the column. You can always pass the results through number_format or similar for formatting in your app.