dosubot[bot] commented on issue #35963: URL: https://github.com/apache/superset/issues/35963#issuecomment-3482588766
<!-- Answer --> Superset determines whether a column is treated as datetime using the is_dttm property in the dataset's column metadata. If a date column with null values isn't recognized as datetime, you can manually set the is_dttm flag for that column in the dataset editor. This ensures Superset generates the correct SQL (using TO_DATE or the appropriate database function) for filtering, even if the column contains nulls or the database type is ambiguous. This override is supported in the metadata layer and doesn't require removing nulls or creating a new dataset. If the UI doesn't expose this toggle, you can update it via the dataset API or by editing the dataset's column metadata directly. This approach is designed to handle cases where type inference fails due to nulls or database quirks, and is the recommended way to resolve your issue. More details on this mechanism are in the codebase and schema definitions ([source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/connectors/sqla/models.py#L510-L1867), [source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/datasets/schemas.py#L44-L75)). <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/01feb87f-9461-4063-84ef-1a68a6f307b0?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/01feb87f-9461-4063-84ef-1a68a6f307b0?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/01feb87f-9461-4063-84ef-1a68a6f307b0?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/01feb87f-9461-4063-84ef-1a68a6f307b0?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/01feb87f-9461-4063-84ef-1a68a6f307b0?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/01feb87f-9461-4063-84ef-1a68a6f307b0?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/01feb87f-9461-4063-84ef-1a68a6f307b0?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/35963) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
