https://community.databricks.com/t5/get-started-discussions/snowflake-filter-query-giving-empty-results-in-databricks-same/m-p/44714#M1074 <P>Changed the format with case Sensitive, same issue.</P> Thu, 14 Sep 2023 07:52:46 GMT Skv 2023-09-14T07:52:46Z https://community.databricks.com/t5/get-started-discussions/snowflake-filter-query-giving-empty-results-in-databricks-same/m-p/44703#M1069 <P>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.</P><P>SELECT * FROM Test.TestSchema.Address where TO_DATE(TO_VARCHAR(MODIFIEDDATE,'YYYY-MM-DD')) = '2023-09-10'</P><P>This Query formed in Databricks taken same in snowflake which is running fine and getting the data.</P><P>May I know what is the issue here.</P> Thu, 14 Sep 2023 06:08:19 GMT https://community.databricks.com/t5/get-started-discussions/snowflake-filter-query-giving-empty-results-in-databricks-same/m-p/44703#M1069 Skv 2023-09-14T06:08:19Z https://community.databricks.com/t5/get-started-discussions/snowflake-filter-query-giving-empty-results-in-databricks-same/m-p/44714#M1074 <P>Changed the format with case Sensitive, same issue.</P> Thu, 14 Sep 2023 07:52:46 GMT https://community.databricks.com/t5/get-started-discussions/snowflake-filter-query-giving-empty-results-in-databricks-same/m-p/44714#M1074 Skv 2023-09-14T07:52:46Z