Re: Error when writing using date aggregate

[Peter Brawley]

Many versions ago, date default was '0000-00-00'.

With what version did this system start? And what version are you running now?

Meanwhile, this is why there's a data dictionary ...

select table_schema,table_name,column_name
from information_schema.columns
where column_default='0000-00-00';

...if you're on 8.0, give those columns appropriate Check Constraint clauses and different defaults, otherwise just give them other defaults till you upgrade.

Then run update queries on those columns to get rid of the zero dates.