title: SQL getdate() in Count query not working correctly
body: <p>I am trying to execute this query against SQL Server 2008:<br><br></p>
  
  <pre><code>SELECT Count(*) FROM tblSharesSentRequests WHERE [SentDate] = getdate()
  </code></pre>
  
  <p>This returns 0 rows, even though I have 1 row with a SentDate set to "2012-7-13"</p>
  
  <p><br><br>
  This SQL statement works fine:</p>
  
  <pre><code>SELECT Count(*) FROM tblSharesSentRequests WHERE [SentDate] = '2012-7-13'
  </code></pre>
  
  <p>it returns 1 row.</p>
  
  <p><br><br>
  Why doesn't it work when I use getdate()?</p>