title: How to select from SQL table WHERE a TIMESTAMP is a specific Date
body: <p>Im trying to do a query where a TIMESTAMP field is = to a specific date but my query is not working:</p>
  
  <p>The field is type TIMESTAMP(6) which I have only ever worked with DATE / DATETIME fields before.  Here is example of a value stored here:  <strong>04-OCT-13 12.29.53.000000000 PM</strong></p>
  
  <p>Here is my SELECT statement: </p>
  
  <pre><code>SELECT * FROM SomeTable WHERE timestampField = TO_DATE('2013-10-04','yyyy-mm-dd')
  </code></pre>
  
  <p>I am retrieving no results and I am assuming it has to do with the fact that its not matching the TIME portion of the timestamp</p>