title: Records within a certain month, when Date is saved System.Data.DbType.Date
body: <p>I have searched the similar questions, and tried the SQL query:</p>
  
  <pre><code>"SELECT * FROM expenses WHERE strftime('%m', date) = 2";
  </code></pre>
  
  <p>which does not work for me (nothing is returned).</p>
  
  <p>When creating a record, to save a date I use Date picker and then a parameter to a command (in a different place, not relating to the query above):</p>
  
  <pre><code>cmd.Parameters.Add("@date", System.Data.DbType.Date).Value =this.dateTimePicker1.Value.Date;
  </code></pre>