I am trying to fetch filter data based on date format on a date column. Below is the query forming in Databricks. In Databricks giving empty results.
SELECT * FROM Test.TestSchema.Address where TO_DATE(TO_VARCHAR(MODIFIEDDATE,'YYYY-MM-DD')) = '2023-09-10'
This Query formed in Databricks taken same in snowflake which is running fine and getting the data.
May I know what is the issue here.