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

Hemanth998
Databricks Partner
 

Aashita
Databricks Employee
Databricks Employee

@Hemanth​ , example :

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

will give

View solution in original post

Aashita
Databricks Employee
Databricks Employee

@Hemanth​  does it work now?