select * from tablename 
where time >= to_date('2011-05-02','yyyy-mm-dd')    
and  time <= to_date('2011-05-30','yyyy-mm-dd') 

select * from tablename 
where to_char(time,'yyyy-mm-dd') >= '2011-05-02'    
and to_char(time,'yyyy-mm-dd') <= '2011-05-30' 

格式化傳入的日期字符串與數(shù)據(jù)庫比較
select * 
from goods
where g_time=to_date('2018/12/26 10:05:17','yyyy-MM-dd hh:mi:ss');

格式化數(shù)據(jù)庫的日期與傳入的日期字符串比較
select *  
from goods
where carnum = '粵BEK735' and 
to_char(damageStartdate, 'yyyy-MM-dd HH24:mi:ss') = '2017-04-05 12:00:00'; 

傳入值與數(shù)據(jù)值模糊匹配
select *  
from goods
where carnum = '粵BEK735' and 
to_char(damageStartdate, 'yyyy-MM-dd HH24:mi:ss')  like '2017-04-05%'; 

        //轉(zhuǎn)換器
        DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
        //當前時間
        LocalDateTime time = LocalDateTime.now();

        //日期轉(zhuǎn)字符串
        String localTime = df.format(time);
        System.out.println("LocalDateTime轉(zhuǎn)成String類型的時間：" + localTime);

        //字符串轉(zhuǎn)日期
        LocalDateTime ldt = LocalDateTime.parse("2017-09-28 17:07:05", df);
        System.out.println("String類型的時間轉(zhuǎn)成LocalDateTime：" + ldt);
        //日期轉(zhuǎn)時間戳
        System.out.println("LocalDateTime：2017-09-28T17:07:05 轉(zhuǎn)時間戳："+ldt.toEpochSecond(ZoneOffset.of("+8")));


        System.out.println("===================================");

        //LocalDateTime把字符串轉(zhuǎn)日期互轉(zhuǎn) （不帶時、分、秒的）
        DateTimeFormatter dateTimeFormatter1 = DateTimeFormatter.ofPattern("yyyy/M/d");
        
        //字符串轉(zhuǎn)日期
        LocalDate parse = java.time.LocalDate.parse("2016/03/28", dateTimeFormatter1);
        System.out.println("2016/03/28轉(zhuǎn)成日期后：" + parse);

        //日期轉(zhuǎn)字符串
        String format = dateTimeFormatter1.format(parse);
        System.out.println("2016/03/28轉(zhuǎn)成合適的字符串后：" + format);

  LocalDate today = LocalDate.now();
  System.out.println("Today：" + today);
  LocalDate oldDate = LocalDate.of(2018, 9, 23);
  System.out.println("OldDate：" + oldDate);

  Period p = Period.between(oldDate, today);
  System.out.printf("目標日期距離今天的時間差：%d 年 %d 個月 %d 天\n", p.getYears(), p.getMonths(), p.getDays());

   DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
   LocalDate ldate = LocalDateTime.parse(settlementDetailRequest.getStartTime(), df).toLocalDate();
   LocalDate rdate = LocalDateTime.parse(settlementDetailRequest.getEndTime(), df).toLocalDate();
   Period p = Period.between(ldate, rdate);

   if (p.getYears() > 1 || p.getMonths() > 3 ||(p.getMonths()==3&&p.getDays()>0)) {
       return BaseResp.fail("查詢?nèi)掌诜秶鷥H支持三個月！");
   }

    @RequestMapping(value = "/memory",method = RequestMethod.GET)
    @ApiOperation("修理廠錄入定損任務-記憶功能")
    @ApiImplicitParam(paramType = "query", name = "openid", value = "修理廠openid", required = true, dataType = "String")
    public R memory(@RequestParam("openid") String openid) {

        // 1.獲取該openid下的所有定損任務
        List<KfAppointmentDsEntity> memoryInfo = kfAppointmentDsService.list(new QueryWrapper<KfAppointmentDsEntity>().eq("factory_openid", openid));

        // 2.收集所有已提交的定損任務的-提交時間戳
        List<Long> collect = memoryInfo.stream()
                .map(KfAppointmentDsEntity::getApplyTime)
                .map(x -> {
                    DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
                    // 把Date格式轉(zhuǎn)化為時間戳
                    return LocalDateTime.parse(x, formatter).toEpochSecond(ZoneOffset.of("+8"));
                }).collect(Collectors.toList());

        // 3.通過比較時間戳大小，收集最近一次的提交時間戳
        Long maxTime = collect.get(0);
        for (int i = 0; i < collect.size(); i++) {
            if (maxTime < collect.get(i)) {
                maxTime = collect.get(i);
            }
        }

        // 4.收集最近一次提交時間的任務信息
        Long finalMaxTime = maxTime;
        List<KfAppointmentDsEntity> entitity = memoryInfo.stream().filter(x -> {
            DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
            Long everyTime = LocalDateTime.parse(x.getApplyTime(), formatter).toEpochSecond(ZoneOffset.of("+8"));
            return everyTime.equals(finalMaxTime);
        }).collect(Collectors.toList());

		// 5.屬性copy，并返回
        MemoryVo memoryVo = new MemoryVo();
        BeanUtils.copyProperties(entitity.get(0),memoryVo);
        return R.ok().put("data",memoryVo);
    }

select * from table where date between '2009-01-22' and '2009-01-23' 

public class MianTest {
    public static void main(String[] args) {

        //轉(zhuǎn)換器
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        //當前日期
        Date date = new Date(2021-1900,1,28);
        System.out.println(format.format(date)+"+++++++++");
        
        Calendar instance = Calendar.getInstance();
        //把當前日期放進去
        instance.setTime(date);
        //日期向后推一天
        instance.add(instance.DATE,1);

        //這個日期就是日期向后推 1天 的結(jié)果
        Date realyTime = instance.getTime();
        System.out.println(format.format(realyTime)+"+++++++++");
    }
}

  //endTime增加一天
  String endTime = vo.getEndTime();
  String replaceTime = endTime.replace("00:00:00", "59:59:59");
  vo.setEndTime(replaceTime);

public class MianTest {
    public static void main(String[] args) {

        //轉(zhuǎn)換器
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        //當前日期
        Date date = new Date(2021-1900,1,8);
        System.out.println(format.format(date)+"+++++++++");

        Calendar instance = Calendar.getInstance();
        //把當前日期放進去
        instance.setTime(date);
        //日期向后推，整數(shù)往后推，負數(shù)向前推
        instance.add(Calendar.HOUR,23);
        instance.add(Calendar.MINUTE,59);
        instance.add(Calendar.SECOND,59);

        //這個日期就是日期向后推 23:59:59的結(jié)果
        Date realyTime = instance.getTime();
        System.out.println(format.format(realyTime)+"+++++++++");
    }
}