title: SQLite comparing time values
body: <p>I've got a time field (HH:MM:SS) in a table and need a query that limits results to all records where the time field is more than 3:00:00</p>
  
  <p>Pretty sure I need to use the time() function somehow, but no matter what I try I either get an error or incorrect resultsets.</p>
  
  <pre><code>select * from table where time_happens &gt; '03:00:00' 
  </code></pre>
  
  <p>...doesn't give an error, but doesn't work correctly. </p>