1.日起格式化工具
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
2.今日日期00:00:00
long l1 = LocalDateTime.of(LocalDate.now(), LocalTime.MIN).toInstant(ZoneOffset.of("+8")).toEpochMilli();
System.out.println( simpleDateFormat.format(l1) );
3.今日日起一周前00:00:00时间
long l1 = LocalDateTime.of(LocalDate.now(), LocalTime.MIN).toInstant(ZoneOffset.of("+8")).toEpochMilli();
System.out.println( simpleDateFormat.format(l1) );
System.out.println("七天前的日期:" + simpleDateFormat.format(l1 - 6 * 24 * 60 * 60 * 1000));
4.今日时间23.59.59时间
//23.59
long l2 = LocalDateTime.of(LocalDate.now(), LocalTime.MAX).toInstant(ZoneOffset.of("+8")).toEpochMilli();
System.out.println( simpleDateFormat.format(l2) );
5…Mybtais时间范围查询
start=开始时间
end为结束时间需要什么时间自己修改在拼接就好了
List<test> test = testMapper.selectList(new QueryWrapper<DayReport>()
.apply("date_format (create_time,'%Y-%m-%d %H:%i:%s') >= date_format('" + start + "','%Y-%m-%d %H:%i:%s')")
.apply("date_format (create_time,'%Y-%m-%d %H:%i:%s') <= date_format('" + end + "','%Y-%m-%d %H:%i:%s')")
.orderByAsc("create_time")
);