How to calculate date diff in the below scenario using databricks sql?
Input –
Query table based on table_name from information_schema in Databricks SQL
I have one table that changes the name every 60 days. The name simple increases the number version, for example:
Databricks function DATE_ADD(DAY, 7, t.openDate) Not recognizing DAY clause
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: