java - 如何查找两个字符串日期之间的记录 SQLITE - Android

Question

这个问题已经有答案了:

Why does this SQLite query select all dates, even those outside of the criteria? (9 个回答)

已关闭 8 年前。

 String start = "9-4-2015";
 String end = "11-4-2015";
 SimpleDateFormat sdf = new SimpleDateFormat("d-M-yyyy");
 List<IncomeModel> allToDos = db.getAllIncomesWeeks();

 for (IncomeModel todo : allToDos) {
    DatabaseDate = todo.getDate();
    try {
          if (sdf.parse(start).before(sdf.parse(end))) {
               incomeModel.add(todo);
               sum = sum + Integer.parseInt(todo.getAmount());
              }
        } catch (NumberFormatException | ParseException e) {
           e.printStackTrace();
    }
  }
  tvSum.setText(sum + "");

我需要开始日期和结束日期之间的记录。我也尝试过这个查询

"SELECT * FROM expenses WHERE date BETWEEN '"+ start + "' AND '" + end + "'" 

但它也显示错误的数据。

Answer 1

您的日期格式必须为 2015-04-09 才能生效。
供您引用:http://sqlite.org/lang_datefunc.html