Snowflake filter Query giving empty results in Databricks, same query working in Snowflake.

[Skv]

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.

[Skv]

Changed the format with case Sensitive, same issue.