1.mysql的datetime-转成date
出现oracle与MySQL事件类型转换出现文字与格式字符串不匹配
MySQL:INSERT INTO book_order
VALUES (‘11’, ‘2’, ‘2’, ‘张三五’, ‘622987745565656’, ‘13918655256’, ‘2’, ‘2019-01-18’, ‘2019-01-19’, ‘’, ‘2019-01-18 23:57:11’);
改成
INSERT into checkin VALUES (‘10’, ‘4’, ‘3’, ‘298.00’, ‘张三五’, ‘622987745565656’, ‘13918655256’, ‘1’, ‘2019-01-18’, ‘2019-01-19’, ‘11’, ‘’,to_date(‘2019-01-19 00:00:08’,‘yyyy/mm/dd HH24:MI:SS’));