I am setting the sql_mode for the MySQL session into non-strict SQL Mode as below on the PDO object.

I have excluded the modes STRICT_ALL_TABLES or STRICT_TRANS_TABLES above. I have a table with createdDate(DATETIME) and updatedDate(DATETIME) columns which are not null and do not have default values.

When I try to make an insert into that table without values for those 2 columns, I still receive an error saying values are not specified for those columns in the insert statement. Ideally the insert queries should work and those 2 columns should have 0000-00-00 00:00:00 as the value for those rows.

Why does this error happen and how can I fix it? I do not want to set the sql_mode for the whole database server into non-strict SQL Mode as it will affect other databases.