title: Oracle SQL "SELECT DATE from DATETIME field "
body: <p>I have field REPORTDATE (DATETIME).
  In SQL Developer i can see its value in this format</p>
  
  <p><code>29.10.2013 17:08:08</code></p>
  
  <p>I found that in order to do the select of just a DATE I need to execute this:</p>
  
  <pre><code>SELECT TO_DATE (REPORTDATE, 'DD.MON.YYYY') AS my_date
  FROM TABLE1
  </code></pre>
  
  <p>but it returns <code>0RA-01843: not a valid month</code></p>
  
  <p>I want result to return only 29.10.2013</p>