title: Redshift where time between 2 times
body: <p>I want to get records between 2 times. The column is in datetime format.</p>
  
  <p>Say, I want to get records between 10am and 2:30pm.</p>
  
  <p>In Mysql, I can write <code>TIME(datetime_col)&gt;='10:00' AND TIME(datetime_col)&lt;='14:30'</code></p>
  
  <p>I am wondering the redshift equivalent of that. </p>
  
  <p>I can try <code>extract(hour from datetime_col)</code> but that won't be correct as I need to consider minutes too.</p>
  
  <p>I could try <code>to_char(datetime_col, 'HH24:MI')</code> but that will not compare with &lt;= or  >=</p>
  
  <p>I am wondering if there is an easy way to achieve it and I am missing it completely.</p>