参考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; }
原文：https://www.cnblogs.com/jnhs/p/12030038.html