需要从前端传过来的年月日查到对于mysql中年月日相等的时间戳
实体类用了Util.Date类型
Ctroller层 前段传来的年月日字符串也加了格式化注解
Dao层 hql也加了Date函数
没查到数据但也没有报错问题在哪里
后台输出的hql如下
Hibernate: select realtimefa0_.id as id1_12_, realtimefa0_.camera_id as camera_i2_12_, realtimefa0_.capturetime as capturet3_12_, realtimefa0_.customer_type as customer4_12_, realtimefa0_.real_time_face_photo_id as real_tim5_12_ from t_realtime_face realtimefa0_ where date(realtimefa0_.capturetime)=? limit ?
对应的sql:select * from realtimeface where capturetime=?
补充:
既然加了@DateTimeFormat注解怎么输出还是这个
上图为数据库的字段