Insert into ecp_chat_message (chatid, content, imgurl, senduserid, sendtime, receiveuserid, state, isread)
Values
(1, 'asdfdf', 'aaa', 'kehu4', to_date ('2017-12-03 12:55:45. 333333 ', 'yyyy-mm-dd hh24: MI: Ss. FF '), 'serviceid', 1, 0)
The following error is reported:
The Date Format Image ends before the entire input string is converted.
You can insert data to the second in this way,
Insert into ecp_chat_message (chatid, content, imgurl, senduserid, sendtime, receiveuserid, state, isread)
Values
(1, 'asdfdf', 'aaa', 'kehu4', to_date ('2017-12-03 12:55:45 ', 'yyyy-mm-dd hh24: MI: ss '), 'serviceid', 1, 0)
Use in milliseconds
Insert into ecp_chat_message (chatid, content, imgurl, senduserid, sendtime, receiveuserid, state, isread)
Values
(1, 'asdfdf', 'aaa', 'kehu4', to_timestamp ('2017-12-03 12:55:45. 333333 ', 'yyyy-mm-dd hh24: MI: Ss. FF '), 'serviceid', 1, 0)
Note that the database field must be changed to the timestamp type.