title: How to get SQFlite data date wise in flutter?
body: <p>I'm creating todo app in flutter. And I need to show Todos date wise. Like all Todos created today should shown under Today, all the tomorrow's Todos should shown under Tomorrow.</p>
  <p><a href="https://i.stack.imgur.com/gqAbX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gqAbX.png" alt="enter image description here" /></a></p>
  <p>I have created my table like this:</p>
  <pre class="lang-dart prettyprint-override"><code>database.execute(&quot;&quot;&quot;
            CREATE TABLE Todotable(
              id INTEGER PRIMARY KEY AUTOINCREMENT,
              taskName TEXT NOT NULL,
              taskTag TEXT NOT NULL,
              date TEXT NOT NULL,
              isReminder INTEGER NOT NULL,
              isCompleted INTEGER NOT NULL
            )
       &quot;&quot;&quot;);
  </code></pre>
  <p>I don't know how to query SQFlite data date wise and format it like <em>Today</em> and <em>Tomorrow</em>. And show in section like today and tomorrow as shown in design.</p>
  <p>Thanks for answers:)</p>