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条件

最新文章

热门文章