Re: Avoid scientific values

Tej_04 · ‎01-06-2025

I am trying to insert data into catalog tables on data bricks but the values are being displayed in scientific notation which i am trying to avoid how do I view the data in standard format

for example - 0.0000000 is being displayed as 0E-7

Alberto_Umana · ‎01-06-2025

Hi @Tej_04,

Can you try with format_number Function.

SELECT format_number(column_name, decimal_places) AS column_name FROM table_name;

https://docs.databricks.com/en/sql/language-manual/functions/format_number.html