title: Oracle select date without time and keep date as data type
body: <p>I have a column name <code>'Cos_Date'</code> with value like 14APR2017:00:00:00.</p>
  
  <p>However, for a new column name <code>'Arrival_Date'</code>, I would like to keep the date information but omit time, and keep the data type as <code>Date</code> but not <code>Character</code>. Ex, 14APR2017.</p>
  
  <p>I have tried:</p>
  
  <pre><code>  select TO_CHAR(Cos_Date, 'DD-MON-YYYY') ARRIVAL_DATE
  </code></pre>
  
  <p>But it will delete time information, but data type turns to <code>Character</code>.</p>
  
  <p>I search on this site, and tried both:</p>
  
  <pre><code>  select TO_DATE(TO_CHAR(Cos_Date, 'DD-MON-YYYY'), 'DD-MON-YYYY')  ARRIVAL_DATE
  </code></pre>
  
  <p>and:</p>
  
  <pre><code>  select TRUNC(Cos_Date) ARRIVAL_DATE
  </code></pre>
  
  <p>But it will not omit time information. </p>
  
  <p>Can I try something else? </p>
  
  <p>Thank you!</p>