title: How do you filter to get data that is in between a certain time of day in IBM DB2
body: <p>I am trying to add a filter condition in the DB2 database.  I am new to it and come from an Oracle background.  I am trying to get records with dates in between today at 4 AM and today at 5 PM only.  I currently have the below query that returns zero results:</p>
  
  <pre><code>db2 =&gt; select datetimeColumn from datetimeExample WHERE datetimeColumn  BETWEEN timestamp(current date) - 1 day + 4 hour AND timestamp(current date) - 1 day + 13 hour
  
  DATETIMECOLUMN
  --------------------------
  
  0 record(s) selected.
  </code></pre>
  
  <p>And here is the data in the table that I believe should show but there is something wrong with condition statement, any help is appreciated</p>
  
  <pre><code>db2 =&gt; select * from datetimeExample
  
  DATETIMECOLUMN
  --------------------------
  2016-06-16-09.38.53.759000
  1988-12-25-17.12.30.000000
  2016-12-25-17.10.30.000000
  2016-06-16-04.10.30.000000
  2016-06-16-05.10.30.000000
  1988-12-25-15.12.30.000000
  1988-12-25-14.12.30.000000
  2016-06-16-12.10.30.000000
  2016-06-16-07.10.30.000000
  2016-06-16-08.10.30.000000
  
  10 record(s) selected.
  </code></pre>