oracle sql 时间比较

SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");String hql = "from BridgeEvalBeamDisplacementEntity where channelcode='"+channelcode +                "' and timeval >=  to_date('" + f.format(c.getTime()) + "', 'yyyy-MM-dd HH24:mi:ss')" +                " and timeval <=  to_date('" + f.format(d.getTime()) + "', 'yyyy-MM-dd HH24:mi:ss')" +                    " order by timeval asc";

网上查的以后查看方便。