Question

java oracle ORA-01722: 无效数字 求指点

public interface SmsRtRepository extends BaseRepository<SmsRt,Long>{
@Query(nativeQuery=true,value="select * from TT_RT_QUEUE where MT_TASK_ID in "
+ "(select TASK_ID from TT_WORKORDER where CREATE_USER in "
+ "(select USER_ID from TM_USER where USER_NAME in (?1) and STATUS = 'A')) "
+ "and SEND_TIME >= to_date(to_char(?2,'yyyy-mm-dd'),'yyyy-mm-dd') "
+ "and SEND_TIME < to_date(to_char(?3,'yyyy-mm-dd'),'yyyy-mm-dd') order by SEND_TIME")
public List<SmsRt> getSmsRtData(List<String> User,String beginTime, String endtime);
}
传入的beginTime 和 endTime参数是2015-10-01 和 2015-10-31
运行到这里就报错了。。
谁帮下。。

Answer 1

SEND_TIME >= to_date(to_char(?2,'yyyy-mm-dd'),'yyyy-mm-dd')

不需要to_char转换了，你传进来就是字符串了，改成
SEND_TIME >= to_date(?2,'yyyy-mm-dd')