I have reformatted a T-SQL DATEADD function to Databricks date_add function. However, I’m getting the error that Databricks doesn’t recognize the ‘DAY’ clause with the following error:

cannot resolve '`DAY`

Can someone let me know what the equivalent clause is for ‘DAY’ in Databricks SQL?