select segment98 from ecs_item_flow eifv where to_date(eifv.segment98,'yyyy-mm-dd') BETWEEN NVL(TO_DATE (:in_date_from,'yyyy-mm-dd'), eifv.segment98) AND NVL(TO_DATE (:in_date_TO+1,'yyyy-mm-dd'),eifv.segment98);報ORA-01858: a non-numeric character was found where a numeric was expected 錯誤.在DB中segment98是varchar2型的.
select segment98 from ecs_item_flow eifv where to_date(eifv.segment98,'yyyy-mm-dd')
BETWEEN NVL(TO_DATE (:in_date_from,'yyyy-mm-dd'),to_date(eifv.segment98,'yyyy-mm-dd'))
AND NVL(TO_DATE (:in_date_TO+1,'yyyy-mm-dd'),to_date(eifv.segment98,'yyyy-mm-dd'));