How to no round formating

[William_Scardua]

Hy guys,

I need to format the decimal values but I can`t round then

have any idea ?

thank you

 

[Kaniz_Fatma · Accepted solution]

Hi @William_Scardua, In Databricks, you can format decimal values without rounding them using a couple of approaches. Let’s explore some options:

1. Using substring: You can use the substring function to extract a specific number of decimal places from your decimal value. For example:

   spark.sql("SELECT SUBSTRING(12.455555, 0, INSTR(12.455555, '.') + 2) AS truncated_value").show()
   

   This will give you the result: 12.45¹.

2. Custom Formatting with format_number: The format_number function allows you to override the default rounding format. You can specify the desired number of decimal places. For instance:

   spark.sql("SELECT FORMAT_NUMBER(12.455555, 2) AS formatted_value").show()
   

   This will display: 12.46².

Remember that these solutions will trim the decimal places without rounding off the values. Choose the one that best fits your requirements! 🚀