title: sql - conversion error when changing 'and' to 'or'
body: <p>I have a database table in sql server 2008.  My query is breaking for a reason that is unknown to me:</p>
  
  <pre><code>select release_id, url_id,tt_projectid, release_title, tech_area, current_state,     dateadd(ss,last_built,'12/31/1969 20:00:00') as recent_Date,
          autobuild_count, manualbuild_count, bcm_build_count, config_count, force_count, transition_only_count,
          auto_integ_count,last_auto_integ,dateadd(ss,integ_complete_date,'12/31/1969 20:00:00') as integ_date
  
          from tablename 
          where (auto_integ_count &gt; 0
          and MONTH(last_auto_integ) = '1'
          and YEAR(last_auto_integ) = '2013')
          and (release_id &gt; 36000)
  
          order by release_id desc
  </code></pre>
  
  <p>The above query works fine, but when I change the last line of the where close from 'and' to 'or' I get this conversion error:</p>
  
  <pre><code>Conversion failed when converting date and/or time from character string.
  </code></pre>
  
  <p>I'm puzzled as to why changing</p>
  
  <pre><code>'and (release_id &gt; 36000)'
  </code></pre>
  
  <p>to</p>
  
  <pre><code>'or (release_id &gt; 36000)'
  </code></pre>
  
  <p>would cause such an error</p>