title: ORA-00920: invalid relational operator
body: <p>In a database, I am trying to pull information that is later than a specified date. I should note beforehand that the date is in an odd format: <code>YYYYMMDDHH24MISS##</code> where <code>##</code> is a two letter string which defines something useless to my query. Thus, I am using <code>substr</code> to just remove them. </p>
  
  <p>My query, below, throws the following error, and I canot find out why:</p>
  
  <blockquote>
    <p>[Error Code: 920, SQL State: 42000]  ORA-00920: invalid relational
    operator</p>
  </blockquote>
  
  <p>My Query:</p>
  
  <pre><code>SELECT *
    FROM table_name
   WHERE to_date(substr(COLUMN_NAME,1,14), 'YYYYMMDDHH24MISS')) &gt;=
         to_date('MIN_DATE', 'YYYYMMDDHH24MISS')
  </code></pre>
  
  <p>I have checked to make sure the dates are being defined correctly, and they are.</p>
  
  <p>Example of what I have used for <code>MIN_DATE</code> is: <code>20140101000000</code></p>