title: how i can retrieve rows by specific date in sql server?
body: <p>I'm working in project for by PHP and SQL Server.</p>
  
  <p>The owner want from me  design page show only users who register in same day</p>
  
  <p>i.e., if today 11-3-2011 i want show only all users who register in 11-3-2011</p>
  
  <p>The table is:</p>
  
  <pre><code>id  username  date
  
  1   john      11\3\2011
  2   sara      11\3\2011
  3   john      5\1\2011
  4   kreem     1\2\2011
  </code></pre>
  
  <p>i make it by mysql </p>
  
  <pre><code>where DATE_ADD( items.created_date, INTERVAL 1 DAY ) &gt; NOW() 
  </code></pre>
  
  <p>this cable of code show data which only insert in same day thats mean if today 10-4-2011 it will show only data which insert in 10-4-2011 if i today 15-4-2011 and im dose not insert any thing it will not show any thing, how i can build code like this in sql server? hope to be my question clear and understand </p>