title: db2 between timestamp query
body: <p>i am new to DB2 can you please help how to execute query in db2 for between timestamp with AM and PM format.</p>
  
  <p>Below is the table</p>
  
  <pre><code>ID   NAME       TIMESTAMP
  ==   ====       =========
  6    Xavier    02/02/2016 2:24:32 AM
  7    Paul      02/02/2016 2:46:53 PM
  8    Adam      02/02/2016 4:05:39 PM
  9    Newton    12/02/2016 5:29:46 PM
  10   Jack      14/02/2016 9:29:46 PM
  </code></pre>
  
  <p>I want to use the above table to select names on 02/02/2016 between 1AM to 4PM</p>
  
  <p>Can you please help to achieve.</p>