title: How to search data between two dates with timestamp in sap hana DB
body: <p><strong>Query</strong></p>
  
  <pre><code>SELECT  * FROM "DD"."kidos.dd.data::DD_RECEIVE_NOTIFICATION_TBL" 
  WHERE RECEIVED_DATE between 
  DATE("2017-11-28T04:41:00.000Z") and DATE("2017-12-01T04:42:00.000Z"); 
  </code></pre>
  
  <p>I have two dates with timestamp. I have to search the data between two dates. In hana <code>DB</code> I initailized <code>"RECEIVED_DATE"</code> with <code>TIMESTAMP</code>. How to filter data's with in two date times.</p>