title: Is it possible to convert a column from string to datetime type in a SQL statement?
body: <p>I need to query SQLite datebase table using the following SQL Statement.</p>
  
  <pre><code>SELECT * 
  FROM Alarms 
  WHERE ALARMSTATE IN (0,1,2) 
    AND ALARMPRIORITY IN (0,1,2,3,4) 
    AND ALARMGROUP IN (0,1,2,3,4,5,6,7) 
    AND DateTime(ALARMTIME) BETWEEN datetime("2012-08-02 00:00:00") 
                      AND datetime("2012-08-03 00:00:00") 
  ORDER BY ALARMTIME DESC
  </code></pre>
  
  <p>ALARMTIME is of TEXT datatype.</p>
  
  <p>ALARMTIME is displayed in the datagridview as follow "08/03/2012 11:52 AM". Can you use that format for checking like DateTime(ALARMTIME)?</p>
  
  <p>The only problem have with this SQL Statement is that it always returns zero dataset or records. However, SQLite doesn't complain about the syntax. </p>