cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Help
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Avoid scientific values

Tej_04
New Contributor

yesterday

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

0 Kudos
1 REPLY 1

Alberto_Umana
Databricks Employee
Databricks Employee

yesterday

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

0 Kudos

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group
Announcements