topic Re: Avoid scientific values in Data Engineering

Avoid scientific values

Tej_04 — Mon, 06 Jan 2025 22:13:27 GMT

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

Re: Avoid scientific values

Alberto_Umana — Mon, 06 Jan 2025 22:35:37 GMT

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