Hi All, I am doing this to move data from one table to other and getting below error. How can check this particular record at this row number 921888 in dats_tem table.
insert into reports1.dats1 select * from dats_tem; ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'P_LAST_SOLD_DATE' at row 921888