Warning: #1292 Incorrect datetime error when using DATE_ADD()
You try to add to the string 'foo' 5 days.
Use backticks for column names
SELECT * FROM table WHERE DATE_ADD(`foo`, INTERVAL 5 DAY) &lt; '2021-01-09 00:00:00'