1.代码实现获取3天时间
public class TimeDemo {
@Test
public void getTime(){
LocalDate localDate = LocalDate.now();
LocalDate localDate1 = localDate.plusDays(1);
LocalDate localDate2 = localDate.plusDays(2);
LocalTime localTime = LocalTime.now();
LocalTime min = LocalTime.MIN;
LocalTime max = LocalTime.MAX;
LocalDateTime start = LocalDateTime.of(localDate, localTime);
String format = start.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
LocalDateTime end = LocalDateTime.of(localDate2, max);
String format1 = end.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
}
}
2.sql 实现获取当天时间
select * form student where create_time BETWEEN DATE_FORMAT( NOW(), '%Y-%m-%d 00:00:00' ) AND DATE_FORMAT( NOW(), '%Y-%m-%d 23:59:59' )
3.时间格式化注解
@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")