title: Perform range query on sqlite datetime column or on string column(which having dateTime)
body: <p>net.dll for performing operations on sqlite. i am facing issue for sqlite database like i am created column as Text name as DateTime and storing date string into it. i want entries which are in between some date range, but i am not able to execute query.</p>
  
  <p>used query for type of DateTime Column as "Date":
  **</p>
  
  <pre><code>SELECT * FROM TableName WHERE ColumnName BETWEEN '1800-1-1' AND '2010-12-12'
  </code></pre>
  
  <p>**</p>
  
  <p>used query for type of DateTime Column as "String":</p>
  
  <p>**</p>
  
  <pre><code>SELECT * FROM MD5_HEADER WHERE Sent BETWEEN '4/1/2007 12:01:00 AM' AND '12/1/2010 4:05:36 AM'
  </code></pre>
  
  <p>**</p>
  
  <p>if anyone having solution regarding this issue please help me.</p>
  
  <p>(c#, Sqlite.net.dll, framework3.5)</p>