title: Compare times in SQLite
body: <p>I am using SQLite in Android to store a timeStamp in this format: <code>yyyy-MM-dd HH:mm:ss</code>
  I would like to compare just the time of the timestamp with some values eg. <code>HOUR(timestamp)&gt;12</code> etc. , but HOUR is not a legal function in SQLite. I have changed it as described below and I have something like this: <code>" where "+" strftime('%H','"+timeStamp+"')&gt;"+time1+" AND strftime('%H','"+timeStamp+"')&lt;'"+time2;</code> where time1 and time2 are integer between 0-23. I have 7 entries in the table so 7 timestamps. however i get 0 results back... </p>