hibernate查询timestamp条件

参考https://blog.csdn.net/zuozuoshenghen/article/details/50540661

Mysql中Timestamp字段的格式为yyyy-MM-dd HH-mm-ss

所以，可以直接把要查询的时间转换为字符串，然后直接查

 public List<ResourseModel> listTodayOrders(Session session) {
        String hql = "FROM ResourseModel WHERE creatTimestamp like '2019-12-12%' ";
        Query query = session.createQuery(hql);
        List<ResourseModel> models = query.list();
        return models;
    }

如果要查询时间段呢，就用大于小于就行了

  public List<ResourseModel> listTodayOrders(Session session) {
        String hql = "FROM ResourseModel WHERE creatTimestamp < '2019-12-12' ";
        Query query = session.createQuery(hql);
        List<ResourseModel> models = query.list();
        return models;
    }

hibernate查询timestamp条件

推荐阅读