How do You get rid of the extra 0's behind the decimal point in mysql
- 2020-06-15 10:24:06
- OfStack
Results of select cast(2.12000 as decimal(9,2)
2.12
Results of select cast(2.10000 as decimal(9,2)
2.1
select cast(2.00000 as decimal(9,2)) results
2
2.12
Results of select cast(2.10000 as decimal(9,2)
2.1
select cast(2.00000 as decimal(9,2)) results
2