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
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: 

What is the equivalent function to oracle trunc() for numerics in databricks?

Go to solution
Hemanth998
New Contributor

‎04-14-2022 11:11 AM

 
Labels:
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions

Go to solution
Aashita
Contributor III
Contributor III

‎04-14-2022 02:48 PM

@Hemanth​ , example :

spark.sql("select substring(25.45678,0, instr(25.45678,'.')+2) as out").show()
 

will give

View solution in original post

3 REPLIES 3

Go to solution
Aashita
Contributor III
Contributor III

‎04-14-2022 02:48 PM

@Hemanth​ , example :

spark.sql("select substring(25.45678,0, instr(25.45678,'.')+2) as out").show()
 

will give

Go to solution
Aashita
Contributor III
Contributor III
In response to Aashita

‎04-20-2022 10:56 AM

@Hemanth​  does it work now?

0 Kudos

Go to solution
Kaniz
Community Manager
Community Manager

‎04-26-2022 03:24 AM

Hi @Hemanth​ , Just a friendly follow-up. Do you still need help, or @Aashita Ramteke​ 's response help you to find the solution? Please let us know.

0 Kudos
Announcements
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.