他们都是大同小异,针对于oracle的to_date格式转换问题,但是我的情况却和上述不一致
sql
select sum(QUANTITY) "sum" from TRANSPORT_TASK_LINE where FROM_CONTRACT='FL01' and TO_CONTRACT ='FL01' and FROM_LOCATION_NO ='03999999' and TO_LOCATION_NO='88' and TRANSPORT_TASK_STATUS='已执行' and PART_NO='FL01-01-00' and
CREATE_DATE <= to_date( concat('2022-02-28',' 23:59:59'), 'YYYY-MM-DD HH:mm:ss' )
上述运行,并无问题,是否和上面三个解答矛盾?
sql追加条件
select sum(QUANTITY) "sum" from TRANSPORT_TASK_LINE where FROM_CONTRACT='FL01' and TO_CONTRACT ='FL01' and FROM_LOCATION_NO ='03999999' and TO_LOCATION_NO='88' and TRANSPORT_TASK_STATUS='已执行' and PART_NO='FL01-01-00' and
CREATE_DATE <= to_date( concat('2022-02-28',' 23:59:59'), 'YYYY-MM-DD HH:mm:ss' ) and CREATE_DATE >= to_date('2022-02-01', 'YYYY-MM-DD' )
提示:ORA-01810: 格式代码出现两次
显然 追加的条件 并不包含所谓的时间问题。由此提出疑问,希望懂得大佬评论区给予解答 谢谢