umesh11111 opened a new issue #8402: Unable to filter by dates in Dashboard.Throws ORA-01843: not a valid month URL: https://github.com/apache/incubator-superset/issues/8402 I have tried to create a dashboard which includes a date column. When I try to open the dashboard and select a filter which is a date column , it gives me ORA-01843: not a valid month error. But when I try to take the query object and run in Oracle DB directly , it works well. But if I run the same query in superset , it throws me error. When I do the below modifications to the query it works : 1.Either add TO_DATE to the values selected .Example where sample_date in TO_DATE('10-10-2019','MM-DD-YYYY') or 2.Add TO_CHAR to the column where TO_CHAR(sample_date,'MM-DD-YYYY) in ('10-10-2019') Why is it like that.I am unable to perform any date comparisons
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
