title: How do I correctly compare dates using to_char?
body: <p>I have a query similar to :</p>
  
  <pre><code>SELECT STUFF 
  FROM TABLENAME
  WHERE TO_CHAR(STARTDATE, 'DD-MON-YYYY') &gt; '01-OCT-2015'
  </code></pre>
  
  <p>My result set contains <code>STARTDATE</code>s that all are less than '01-OCT-2015'</p>
  
  <p>What am I doing wrong?  Thanks so much!</p>