title: oracle SQL how to remove time from date
body: <p>I have a column named <code>StartDate</code> containing a date in this format: <code>03-03-2012 15:22</code></p>
  
  <p>What I need is to convert it to date. It should be looking like this: <code>DD/MM/YYYY</code></p>
  
  <p>What I have tried without success is:</p>
  
  <pre><code>select 
  p1.PA_VALUE as StartDate,
  p2.PA_VALUE as EndDate
  from WP_Work p 
  LEFT JOIN PARAMETER p1 on p1.WP_ID=p.WP_ID AND p1.NAME = 'StartDate'
  LEFT JOIN PARAMETER p2 on p2.WP_ID=p.WP_ID AND p2.NAME = 'Date_To'
  WHERE p.TYPE = 'EventManagement2'
  AND TO_DATE(p1.PA_VALUE, 'DD/MM/YYYY') &gt;= TO_DATE('25/10/2012', 'DD/MM/YYYY')
  AND TO_DATE(p2.PA_VALUE, 'DD/MM/YYYY') &lt;= TO_DATE('26/10/2012', 'DD/MM/YYYY')
  </code></pre>
  
  <p>Is there a way to do this?</p>
  
  <p>EDIT1: the <code>PA_VALUE</code> column is: <code>VARCHAR2</code></p>