Re: Error Code: 1292. Incorrect datetime value: 'null'

[Phil Siyam]

It worked when if set sql_mode =''

SET sql_mode = '';

Insert into mdm_fms.`test_src` (col_a)
select line_no from view_temp where product_id in ('3100022', 2000000360)

I channged sql_mode from NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES,

to
NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES, ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO, ALLOW_INVALID_DATES

But still getting error.

I am using MySQL 8.0.23 on AWS