databricks python dateadd

Question

Hello,
I am running a sql query in python cell of databricks notebook as follows
...
WHERE \
p.workDATE >= DATEADD(M, -9, GETDATE()) \
...

I get error on:
modular_df = spark.sql(sql)

Undefined function: 'DATEADD'

Question:
How do I correct this?
Thank you

Answer 1

Hi @arkiboys ,

Thank you for posting query in Microsoft Q&A Platform.

In Pyspark SQL we should use different functions. In your case you should consider using add_months() function.

Please check below screenshot to get idea.

Hope this helps. Please let us know if any further queries.

---------
Please consider hitting Accept Answer button. Accepted answers help community as well.