title: Sqlite compare with current date only
body: <p>I am storing the date in the format <code>yyyy-MM-dd</code>. I compare this with the current date. The query is like so:</p>
  
  <pre><code>public Cursor getData() {
      SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();        
      String queryGetData = "SELECT * FROM " + TABLE_NAME 
                + " WHERE " + SEARCH_DATE + " &gt;=  date('now') LIMIT 5";
      Cursor result = sqLiteDatabase.rawQuery(queryGetData, null);
      return  result;
  }
  </code></pre>
  
  <p>The problem with this is that the query does not return any results if they were created at an earlier time (but still on the same day). Again I am only saving the date part in the database not the time.</p>
  
  <p>What is causing this behaviour?  </p>