title: Mysql: Interval time of a day and a half
body: <p>I'm looking for ways to do it from 6:00pm yesterday and on till the next day at 8:00am to report back. Currently, this just gives me all of yesterdays and today's report.</p>
  
  <p>That's my code for reporting on activities that haven't completed. </p>
  
  <pre><code>and A.scheduled_start &gt; DATE_FORMAT(date_sub(now(), INTERVAL 36 HOUR), '%Y-%m-%d 23:59:59') 
  and A.status != 'completed'
  </code></pre>
  
  <p>Thanks!</p>