title: Report For Every Day But Skipping 2 hours
body: <p>I am using the following query to generate employee report for every day</p>
  <p>Employee Report For Yesterday (12:00 to 12:00)</p>
  <pre><code>SELECT * FROM emp WHERE DATE(created) = DATE(NOW() - INTERVAL 1 DAY);
  </code></pre>
  <p> 
  Employee Report For 24 Hours from Current Time When Job is running
   </p>
  <pre><code>SELECT * FROM emp WHERE (created &gt; DATE_SUB(NOW(), INTERVAL 1 DAY));
  </code></pre>
  <p>In both the reports i want to skip records from 10:00 am. to 11:00 a.m and 4:00 p.m to 5:00 p.m records on that day</p>
  <p>Please help me on how to do it?</p>
  <p>Thanks</p>