I have MySQL table with following columns...
Max Wage-limit decimal(14,2)
In above table,I am stored the values of front end application .Here "Rate" column want to accept 6 digits after "dot"
That why I am putting the decimal(8,6) up-to now, no problem at all,but I want display same data in the front end application grid view ,I am shown these data comfortably.
The following situation like user enter
"Rate:" 10 but it store foramt of 10.000000
But same data is display in grid-view "it like in-comfort"
here I want to trim zero of unwanted
I want these format only.
like that if any value like
1.245789 i want display as it is
1.589000 display in 1.5890
like that I want trim the zeros of table at the time of selection.