Mysql > insert a record into an oracle table
ORA-01858: date format picture ends before converting entire input string
SQL statement failed to insert:
Insert into user_baseinfo(id, end_date) values(1, to_date('2020-01-01 01:01:01.000 ', 'yyyy-mm-dd '));
Reason analysis:
The date format passed in does not correspond to the given format
The modified SQL was successfully inserted into the table
insert into user_baseinfo(id, end_date)
values(1, to_date('2020-01-01', 'yyyy-MM-dd'));