那位那位高手帮忙看看这个语句哪错了,谢谢了!Stringhql="fromWisAnotherChildaswwhere((Todate(w.validdate,'yyyy-mm-ddhh24-mi-ss')>Todate((selectsysdatefromdual),'yyyy-mm-ddhh24-mi-ss'))";

Question

那位那位高手帮忙看看这个语句哪错了,谢谢了!
String hql = "from WisAnotherChild as w where ((To_date(w.validdate , 'yyyy-mm-dd hh24-mi-ss') > To_date((select sysdate from dual),'yyyy-mm-dd hh24-mi-ss')) ";

Answer 1

from WisAnotherChild w
where w.validdate > (select sysdate from dual)
这样写就可以了,validdate和sysdate 都是日期的格式,所以不用再转了.