Date date1 = new Date();
Long times = new Date().getTime() - 1000 * 24 * 60 * 60;
date1.setTime(times);
Date date2 = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
String startTime = sdf.format(date1);
String endsTime = sdf.format(date2);
List list = tfeepaidDao.queryTfeepaidSucc(startTime, endsTime);
@Query(value = "select * from tfeepaid where fstatus in (1,2) and flastcommit>=?d1 and flastcommit<?d2", nativeQuery = true)
List<Tfeepaid> queryTfeepaidSucc(String d1, String d2);
![图片说明](https://img-ask.csdn.net/upload/201903/12/1552370821_836933.png)