时间戳

首页 > 解决方案 > 如何根据当前日期过滤记录？

java - 如何根据当前日期过滤记录？

问题描述

我正在实现一个功能，我以字符串形式存储日期，并使用 LocalDate 函数获取字符串中的当前日期，所以我想比较两个日期，我只想获取当前日期记录。

未发现错误，但无法获取记录。

  public ArrayList<Followup_Model> followup_reminder (ArrayList<Followup_Model> followup_Model_list) {
    if (followup_Model_list == null) {
        followup_Model_list = new ArrayList<>();
    }
    SQLiteDatabase sqLiteDatabase = this.getReadableDatabase();
    DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy/MM/dd");
    LocalDate localDate = LocalDate.now();
    String Today = dtf.format(localDate);
    Cursor followup_output = sqLiteDatabase.rawQuery("SELECT * FROM " + Table_Name_Followup +
            " WHERE CREATEDBY = '1' AND CHECKED = '1' AND STARTDATE = " + Today +
            " ORDER BY REMINDER ASC",null);

标签： javaandroidsqlitedate

解决方案

只需复制和粘贴。 

public ArrayList<Followup_Model> followup_reminder (ArrayList<Followup_Model> 
 followup_Model_list) {
    if (followup_Model_list == null) {
        followup_Model_list = new ArrayList<>();
    }
    SQLiteDatabase sqLiteDatabase = this.getReadableDatabase();
    DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy/MM/dd");
    LocalDate localDate = LocalDate.now();
    String Today = dtf.format(localDate);
    Cursor followup_output = sqLiteDatabase.rawQuery("SELECT * FROM " + Table_Name_Followup +
            " WHERE CREATEDBY = '1' AND CHECKED = '1' AND STARTDATE = '" + Today + "'" +
            " ORDER BY REMINDER ASC",null);

推荐阅读