title: Between clause for cakephp 3
body: <pre><code>select * from user where HOUR(NOW()) BETWEEN earliest_login AND latest_login
  </code></pre>
  
  <p><code>earliest_login</code>, <code>latest_login</code> are two columns .</p>
  
  <p>Please let me know how I can write this in cakephp3</p>
  
  <p>code I have tried is:</p>
  
  <pre><code>$query-&gt;where(
      [
          function($exp) {
              return $exp-&gt;between('HOUR(NOW())', 'earliest_login', 'latest_login');
          }
  </code></pre>
  
  <p>it is not working .</p>
  
  <p>Please let me know if anyone has a solution.</p>