相关代码如下:
private static Date getStartTime() {
Calendar todayStart = Calendar.getInstance();
todayStart.set(Calendar.HOUR_OF_DAY,0);
todayStart.set(Calendar.MINUTE,0);
todayStart.set(Calendar.SECOND,0);
todayStart.set(Calendar.MILLISECOND,0);
return todayStart.getTime();
}
private static Date getEndTime() {
Calendar todayEnd = Calendar.getInstance();
todayEnd.set(Calendar.HOUR_OF_DAY,23);
todayEnd.set(Calendar.MINUTE,59);
todayEnd.set(Calendar.SECOND,59);
todayEnd.set(Calendar.MILLISECOND,999);
return todayEnd.getTime();
}
User answerRecord = userTemplate.findOne(Query.query(where("createtime")
.gte(getStartTime())
.lte(getEndTime())
.and("id").is("12456")), User.class);
对应的查询语句为:
{ "createtime" : { "$gte" : { "$date" : "2018-10-16T16:00:00.000Z"} , "$lte" : { "$date" : "2018-10-17T15:59:59.999Z"}} , "id" : "12456"}