title: Retrieve date wise data from database in Android
body: <p>In my database I have 1 table with <code>date</code> as one of the column, which stores the date when user add some data in my table.</p>
  
  <p>Now I want to retrieve the data for the current month alone. I searched through Google but didn't get appropriate answer.</p>
  
  <p>My table creation code:</p>
  
  <pre><code>"create table incomexpense(
      _id integer primary key autoincrement,
      "+"price text not null,description text not null,
      "+"quantity text not null,
      "+"total text not null,
      "+"category text not null,
      "+"recurrence text not null,
      "+"date text not null,
      "+"groups text not null,
      "+" recurrenceid text not null);";
  </code></pre>
  
  <p>Can anyone please help how to get the date of 7th day form the current date.</p>