Help Refactor T-SQL Code to Databricks SQL

Carlton — Sun, 21 Apr 2024 18:33:56 GMT

Hello Community

Can someone help refactor the following T-SQL Code to Databricks SQL

CONVERT(DECIMAL(26, 8), ISNULL(xxx.xxxxxxx * ISNULL(RH.xxxxx, 1 / NULLIF(ST.xxxxxx, 0)), ST.xxxxx)) AS Amount

When I attempt to execute the above code I get the following error:

Error in SQL statement: AnalysisException: Undefined function: 'CONVERT'.

Re: Help Refactor T-SQL Code to Databricks SQL

AmanSehgal — Mon, 22 Apr 2024 01:02:45 GMT

You can use CAST instead.

Eg:

SELECT cast('2024' as int);