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'));