varbinary in databricks

Question

Hi Expert,

how we can convert below code into databricks notebook

Convert(Decimal(9,2),Convert(varbinary(4),substring(ac.at_desc,9,4))*1/100.00) as 'test'

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.
With Spark DataFrame API, you can do as following:

your_dataframe.withColumn(
    'test',
    (col('at_desc').substr(9, 4).cast('binary') * 1 / 100.00).cast('decimal(9,2)')
)

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **