title: Display record older than 3 months in sql
body: <p>I need to create a SSIS package that will go through the records in one <code>table(T1)</code> older than <strong>3 months</strong> (based on <code>ALERT_TIMESTAMP</code>) and move them to another <code>table(T2)</code></p>
  
  <p>My query is :</p>
  
  <pre><code>SELECT * FROM T1
  WHERE (DATEDIFF([month], ALERT_TIMESTAMP, GETDATE()) &gt; 3)
  </code></pre>
  
  <p><code>Alert_timestamp</code> column is in <code>Datetime</code> format. eg: <code>'10/26/2012 12:00:00 AM'</code></p>
  
  <p>When I run the query it should display all the records that are older than <strong>3 months</strong>, but it does not.</p>