title: SQL get current date with specific time
body: <p>I am trying to get orders which are approved between 8AM and 4PM</p>
  
  <pre><code>SELECT 
      * 
  FROM 
      orders 
  WHERE 
      approved_date BETWEEN 'CURDATE() 8:00:00' AND 'CURDATE() 16:00:00'
  </code></pre>
  
  <p>Here I am trying to get orders which are approved after 4PM  (till next working day 8AM)</p>
  
  <pre><code>SELECT 
      * 
  FROM 
      orders 
  WHERE 
      approved_date BETWEEN 'CURDATE() 16:00:00' AND 'NEXT_WORKING_DAY 8:00:00'
  </code></pre>
  
  <p>How to write these queries correctly?</p>
  
  <p><em>approved_date</em> is <strong>DATETIME</strong> format (0000-00-00 00:00:00)
  using MySQL</p>
  
  <p>Edit: working day = monday tuesday wednesday thursday friday</p>