在使用如下HQL语句查询时候,报错“could not execute query”
String queryString = "from Message where TO_TIMESTAMP(inserttime,'yyyymmddhh24miss,ff3')>TO_TIMESTAMP(20080905153913,013,'yyyymmddhh24miss,ff3')";
不知是否HQL不能执行TO_TIMESTAMP函数?本语句在Oracle中可以成功执行!
String queryString = "from Message where TO_TIMESTAMP(inserttime,'yyyymmddhh24miss,ff3')>TO_TIMESTAMP(20080905153913,013,'yyyymmddhh24miss,ff3')";
不知是否HQL不能执行TO_TIMESTAMP函数?本语句在Oracle中可以成功执行!
如
('20080905153913,013','yyyymmddhh24miss,ff3')
用sql的话是可以的