title: Why is my SQLite Query using "less than or equal to" not returning the "equal to" part, just the "less than" part?
body: <p>I have a SQLite database with this data in it:</p>
  
  <pre><code>select Id,TimeStamp from MyTable;
  
  ID  TimeStamp
  1   2019-07-15T18:18:44.829Z
  2   2019-07-15T18:18:53.251Z
  3   2019-07-15T18:18:59.475Z
  4   2019-07-15T18:19:15.139Z
  5   2019-07-15T18:20:10.499Z
  6   2019-07-15T18:20:28.91Z
  7   2019-07-15T20:41:32.069Z
  8   2019-07-15T20:41:42.344Z
  9   2019-07-15T20:42:09.124Z
  10  2019-07-15T20:42:26.806Z
  11  2019-07-16T15:06:27.394Z
  12  2019-07-16T15:06:39.871Z
  13  2019-07-16T15:06:49.397Z
  14  2019-07-16T15:06:56.887Z
  15  2019-07-16T15:07:04.288Z
  16  2019-07-16T15:07:34.156Z
  17  2019-07-16T15:07:56.606Z
  18  2019-07-16T15:08:23.908Z
  19  2019-07-16T15:08:51.135Z
  20  2019-07-16T15:09:29.955Z
  21  2019-07-16T15:09:57.523Z
  22  2019-07-16T15:10:17.277Z
  23  2019-07-16T15:10:43.056Z
  24  2019-07-16T15:10:53.924Z
  25  2019-07-16T15:11:49.575Z
  26  2019-07-16T15:12:39.563Z
  27  2019-02-01T15:07:04.288Z
  28  2019-02-02T15:07:04.288Z
  29  2019-02-03T15:07:04.288Z
  30  2019-02-04T15:07:04.288Z
  31  2019-02-05T15:07:04.288Z
  32  2019-03-06T15:07:04.288Z
  33  2019-03-07T15:07:04.288Z
  34  2019-03-08T15:07:04.288Z
  35  2019-03-09T15:07:04.288Z
  36  2019-03-10T15:07:04.288Z
  37  2019-04-11T15:07:04.288Z
  38  2019-04-12T15:07:04.288Z
  39  2019-04-13T15:07:04.288Z
  40  2019-04-14T15:07:04.288Z
  41  2019-04-15T15:07:04.288Z
  42  2019-05-16T15:07:04.288Z
  43  2019-05-17T15:07:04.288Z
  44  2019-05-18T15:07:04.288Z
  45  2019-05-19T15:07:04.288Z
  46  2019-05-20T15:07:04.288Z
  </code></pre>
  
  <p>As you can see, the first dates inserted into the db (ID 1-26)) are within the period <code>2019-07-15</code> to <code>2019-07-16</code>. The later dates (ID 27-46) are within the period <code>2019-02-01</code> to <code>2019-05-20</code>.</p>
  
  <p>However, when I run a query with "less than or equal to" in it, it only returns the less than data:</p>
  
  <pre><code>SELECT ID,TimeStamp FROM MyTable WHERE TimeStamp &gt;= '2019-02-03' AND TimeStamp &lt;= '2019-07-15' order by TimeStamp;
  SELECT ID,TimeStamp FROM MyTable WHERE TimeStamp &gt;= date('2019-02-03') AND TimeStamp &lt;= date('2019-07-15') order by TimeStamp;
  SELECT ID,TimeStamp FROM MyTable WHERE TimeStamp BETWEEN '2019-02-03' AND '2019-07-15' order by TimeStamp;
  SELECT ID,TimeStamp FROM MyTable WHERE TimeStamp BETWEEN date('2019-02-03') AND date('2019-07-15') order by TimeStamp;
  
  29  2019-02-03T15:07:04.288Z
  30  2019-02-04T15:07:04.288Z
  31  2019-02-05T15:07:04.288Z
  32  2019-03-06T15:07:04.288Z
  33  2019-03-07T15:07:04.288Z
  34  2019-03-08T15:07:04.288Z
  35  2019-03-09T15:07:04.288Z
  36  2019-03-10T15:07:04.288Z
  37  2019-04-11T15:07:04.288Z
  38  2019-04-12T15:07:04.288Z
  39  2019-04-13T15:07:04.288Z
  40  2019-04-14T15:07:04.288Z
  41  2019-04-15T15:07:04.288Z
  42  2019-05-16T15:07:04.288Z
  43  2019-05-17T15:07:04.288Z
  44  2019-05-18T15:07:04.288Z
  45  2019-05-19T15:07:04.288Z
  46  2019-05-20T15:07:04.288Z
  </code></pre>
  
  <p>No matter which query I run, I never get the data equal to <code>2019-07-15</code>, which I would think I should as I am using "less than or equal to".</p>
  
  <p>Why is this not working?</p>