title: How to increase the duration logic in SQL SP
body: <p>I have a stored procedure which deletes the records from DB based on following logic.</p>
  <pre><code>     Select Id into #deleterecords from pricetable where 
       ((Convert(date, modifiedon) &lt;&gt; convert(date,gatedate())
  </code></pre>
  <p>I would like to add one more day in     Gatedate()</p>
  <p>I’m trying in this</p>
  <pre><code>       Select Id into #deleterecords from pricetable where 
       ((Convert(date, modifiedon) &lt; &gt; convert(date,gatedate()+1)
  </code></pre>
  <p>It’s not working.</p>
  <p>How can I add one more day?</p>