topic What is the equivalent function to oracle trunc() for numerics in databricks? in Data Engineering https://community.databricks.com/t5/data-engineering/what-is-the-equivalent-function-to-oracle-trunc-for-numerics-in/m-p/22792#M15675 Thu, 14 Apr 2022 18:11:46 GMT Hemanth998 2022-04-14T18:11:46Z What is the equivalent function to oracle trunc() for numerics in databricks? https://community.databricks.com/t5/data-engineering/what-is-the-equivalent-function-to-oracle-trunc-for-numerics-in/m-p/22792#M15675 Thu, 14 Apr 2022 18:11:46 GMT https://community.databricks.com/t5/data-engineering/what-is-the-equivalent-function-to-oracle-trunc-for-numerics-in/m-p/22792#M15675 Hemanth998 2022-04-14T18:11:46Z Re: What is the equivalent function to oracle trunc() for numerics in databricks? https://community.databricks.com/t5/data-engineering/what-is-the-equivalent-function-to-oracle-trunc-for-numerics-in/m-p/22793#M15676 <P>@Hemanth​&nbsp;, example :</P><PRE><CODE>spark.sql("select substring(25.45678,0, instr(25.45678,'.')+2) as out").show() &nbsp;</CODE></PRE><P></P><P>will give</P><P></P> Thu, 14 Apr 2022 21:48:38 GMT https://community.databricks.com/t5/data-engineering/what-is-the-equivalent-function-to-oracle-trunc-for-numerics-in/m-p/22793#M15676 Aashita 2022-04-14T21:48:38Z Re: What is the equivalent function to oracle trunc() for numerics in databricks? https://community.databricks.com/t5/data-engineering/what-is-the-equivalent-function-to-oracle-trunc-for-numerics-in/m-p/22794#M15677 <P>@Hemanth​&nbsp; does it work now?</P> Wed, 20 Apr 2022 17:56:57 GMT https://community.databricks.com/t5/data-engineering/what-is-the-equivalent-function-to-oracle-trunc-for-numerics-in/m-p/22794#M15677 Aashita 2022-04-20T17:56:57Z