1、获取N天前的日期
public static String getOldDate(int distanceDay) { SimpleDateFormat dft = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//日期时间格式要根据数据库格式改变 Date beginDate = new Date(); Calendar date = Calendar.getInstance(); date.setTime(beginDate); date.set(Calendar.DATE, date.get(Calendar.DATE) - distanceDay); //减号为N天前 // date.set(Calendar.DATE, date.get(Calendar.DATE) + distanceDay); //加号为N天后 Date endDate = null; try { endDate = dft.parse(dft.format(date.getTime())); } catch (ParseException e) { e.printStackTrace(); } return dft.format(endDate); }
2、构建查询方法
//获取 当日数据 public ArrayList<InfoModel> getDayData() { List<InfoModel> bpList = new ArrayList<InfoModel>(); SQLiteDatabase db = this.getReadableDatabase(); String selection = "time >?"; String selectionAr