Remove “.000000” from a field like this: “2386.000000”

How do I remove the “.000000” part of the “2386.000000” field? I want to leave only the numerical part before the dot in databricks

Answer

You can use cast

select cast(2386.000000 as int) i