title: How to convert Date-time into Date using Netezza
body: <p>I am doing some calculation but my calculation is off because my date field is showing the time-stamp and i only want to use as Date only when i am doing the calculation.  How can i just ignore the minutes and just use the date when doing the calculation?  Here is what i have:</p>
  
  <pre><code>SELECT EF.DSCH_TS,
         CASE WHEN EXTRACT (DAY FROM  EF.DSCH_TS - EF.ADMT_TS)&gt;=0 THEN 'GroupA' END AS CAL
  FROM MainTable EF;
  </code></pre>