使用hibernateTemplate的find时,hql语句写成:"from Bill as b where date__format(b.endTime, '%Y-%m-%d') between ? and ? and b.parName = ?",执行时就报错,去掉后面的“and b.parName = ?"就可以运行,请问怎么才能使加上最后那段之后不出错?
报错信息贴下,parName的值引号引下试试