title: comparing createddate column with getdate() function
body: <p>I have a datetime column - createddatetime with this value 2015-02-10 23:54:02.000</p>
  
  <p>All I have to do is to compare ONLY THE DATE with getdate() function (Time can be ignored)</p>
  
  <p>How should the query be written.</p>
  
  <p>the pseudo query is:</p>
  
  <pre><code> select * from table where createddatetime(only date) = getdate(only date) 
  </code></pre>