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

[Aashita · Accepted solution]

@Hemanth​ , example :

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

will give

[Aashita]

@Hemanth​  does it work now?