How to bypass the error when adding a column to the database?

Question

MySQL

Hello. I'm trying to add an extra column to the database in a table with stocks. This error pops up: #1067 - Incorrect default value for 'date_start'. What can you think of? OpenServer, if anything

Answer 1

In MySQL 5.7 and above, strict date validation is used by default. An empty value or 0000-00-00 is invalid.
You need to set the correct default value, or set the mode to ALLOW_INVALID_DATES .

Answer 2

When you create a new column, you are probably specifying a default value, and you are probably trying to use the value 0 for the date. Although, if the default value is used, it must be set correctly in terms of the Unix epoch (01/01/1970 and younger).