title: C# Finisar SQLite DateTime Comparison Problem
body: <p>My "task" database table look like this:</p>
  
  <pre><code>[title] [content] [start_date] [end_date]
  [...] [...] [01.06.2010 20:10:36] [06.06.2010 20:10:36]
  [...] [...] [05.06.2010 20:10:36] [06.06.2010 20:10:36]
  </code></pre>
  
  <p>And I want to find only those records that meet the condition that a given day is between start_date and end_date.</p>
  
  <p>I've tried the following SQL expression:</p>
  
  <pre><code>SELECT * FROM task WHERE
  strftime ('%d', start_date) &lt;= @day
  AND
  @day &lt;= strftime ('%d', end_date)
  </code></pre>
  
  <p>Where @day is an SQLiteParameter (eq 5). But no result is returned.</p>
  
  <p>How can I solve this problem?</p>
  
  <p>Thanks.</p>