Incorrect DATETIME value on GET data using SQL Mode

Hello, I am getting this error message:

Incorrect DATETIME value

When trying to get data using SQL Mode, do you know why it is happening? Previously I am sure it is working fine with my current query.

Can you tell us more about which database it is, and what's the query?