title: Select between date range and specific time range
body: <p>Is there a way to Select records between dates and specific time range. For example all the records from 2013-11-01 to 2013-11-30 between hours 05:00 to 15:00. Here what i made until now.</p>
  
  <pre><code>    select count(*) as total from tradingaccounts accounts
  inner join tradingaccounts_audit audit on audit.parent_id = accounts.id
  where date(audit.date_created) between date('2013-11-01 00:00:00') AND date('2013-11-01 23:59:59') 
  </code></pre>
  
  <p>But how am I going to set the specific time range?</p>