Error Code: 1292. Incorrect datetime value: 'null'
Posted by:
Phil Siyam
Date: August 10, 2021 09:37PM
Hi,
I am getting error message : Error Code: 1292. Incorrect datetime value: 'null' when trying to insert data into table using select
Neither table has timestamp field , view_temp has timestamp values but stored in varchar field and are not part of query out put.
CREATE TABLE mdm_fms.`test_tar` ( `col_a` int DEFAULT NULL )
-- Running Query seperately
select line_no from view_temp where product_id in ('3100022', 2000000360)
Out put
10
11
Insert into mdm_fms.`test_src` (col_a)
select line_no from view_temp where product_id in ('3100022', 2000000360)
Error Code: 1292. Incorrect datetime value: 'null'
--- Works fine
Insert into mdm_fms.`test_src` (col_a)
values (10),(11)
2 row(s) affected Records: 2 Duplicates: 0 Warnings: 0
Subject
Views
Written By
Posted
Error Code: 1292. Incorrect datetime value: 'null'
3233
August 10, 2021 09:37PM
994
August 10, 2021 09:43PM
737
August 11, 2021 12:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.