如何根据当前日期过滤记录？
我正在实现一种功能，我以String形式存储日期并通过使用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);
写回答
-
精于基础，广于工具，熟于业务。String Today = dtf.format(localDate);建议把这一句打印出来看一下，是否很您数据库中存储的一致。
2019-10-10 16:20:29赞同 展开评论 打赏 -
只需复制并粘贴。
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);
2019-10-09 19:08:06赞同 展开评论 打赏
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
