In file /superset/db_engine_specs/cockroachdb.py need to add the override method:
|
if isinstance(sqla_type, Date): |
|
return f"TO_DATE('{dttm.date().isoformat()}', 'YYYY-MM-DD')" |
And change to the TO_CHAR function:
return f"TO_CHAR('{dttm.date().isoformat()}', 'YYYY-MM-DD')"