- 4901 Views
- 2 replies
- 4 kudos
Why does Databricks SQL drop ending 0 in decimal data type
All,I have a column, RateAdj that is defined as DECIMAL(15,5) and I can see that the value is 4.00000, but when this gets inserted into my table it shows as just 4.%sql SELECT LTRIM(RTRIM(IFNULL(FORMAT_NUMBER(RateADJ, '0.00000'), '0.00000')))This i...
- 4901 Views
- 2 replies
- 4 kudos
Latest Reply
- 4 kudos
Hi @Greg Bradley Hope everything is going great.Checking in. If @Uma Maheswara Rao Desula answer helped, would you let us know and mark the answer as best? If not, would you be happy to give us more information?Thanks!
- 4 kudos