Hi!
I have an error while trying to cache model:
The model query works fine:
Hey, it might be that you have MySQL running on Strict Mode.
Model caching will write the results of the query to a schema in your Metabase's application database. That write operation must be running with some stricter requirements than the read operation (which is why your query works in the SQL editor, but not during caching).
This thread might help: mysql - Truncated incorrect date value - Stack Overflow