title: Select records from SQL Server if greater than 6 months
body: <p>I am creating an MVC app where I need to send out an email to all those records whose value (<code>DateUpdated</code>) are not updated in the <code>Customer</code> table. </p>
  
  <p>My <code>Customer</code> table looks like this:</p>
  
  <pre><code>ID (PK)  
  Name  
  Address  
  DateLastUpdated
  </code></pre>
  
  <p>Now I have this MySql query: </p>
  
  <pre><code> SELECT * FROM users WHERE DateLastUpdated &gt;= NOW() - INTERVAL 6 MONTH 
  </code></pre>
  
  <p>How I will write it in T-SQL and perform this task in MVC3? Please help!</p>