SQL语句因为日期格式问题报错:ORA-01756:quoted string not properly terminated。
错误含义:引用字符串不正确的终止。
报错SQL例句:select * from tb_business_order where business_time between '2020-06-15' and '2020-07-15';
修改报错语句:select * from tb_business_order where business_time between to_date('2020-06-15 00:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('2020-07-15 00:00:00','yyyy-mm-dd hh24:mi:ss') ;
其中“HH24:MI:SS”为24小时制