title: SQLITE group by
body: <p>I use the sql below in sqlite to group by time intervals.  The first is group by day and the second group by hour:</p>
  
  <pre><code>select strftime('%Y-%m-%dT%00:00:00.000', date_time),line, count() from entry group by strftime('%Y-%m-%dT%00:00:00.000', date_time)
  
  select strftime('%Y-%m-%dT%H:00:00.000', date_time),line, count() from entry group by strftime('%Y-%m-%dT%H:00:00.000', date_time)
  </code></pre>
  
  <p>How do I group by 10 minutes interval</p>