title: Select Dates where time is less or equal to '12:00' Oracle
body: <p>I require a query that selects rows where the time is less or equal to 12:00
  I had something like this in mind:</p>
  
  <pre><code>SELECT daterow FROM datecolumn WHERE daterow &lt;= TO_DATE('12:00, HH24:MI')
  </code></pre>
  
  <p>However i get an error: </p>
  
  <pre><code>ORA-01843: not a valid month
  </code></pre>
  
  <p>How would i go about to get all rows that have a time less than 12:00 mid-day?</p>