title: How can I improve performance of a query with the DATE() function?
body: <p>I would like to compare the date field with time stamp filed, but the below date conversion taking long time and causing performance issue, could you please tell another alternate way in db2?</p>
  
  <pre><code>date_record &lt;&gt; date(date_rec_CREATE_GMTS) 
  </code></pre>
  
  <p>where date_record - date type and date_rec_CREATE_GMTS TimeStamp. please help me?</p>