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?

[Kaniz]

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.