title: Getting all rows created today
body: <p>I am unable to get all the rows created today. I have used multiple functions like <code>getdate()</code>, <code>Cast</code>, <code>Convert</code>, etc. but all in vain. </p>
  
  <p>This is my basic query:</p>
  
  <pre><code>SELECT timeId
  FROM table_roaster_time_table
  WHERE (user_id = @user_id) AND (DATEDIFF(d, date, GETDATE()) = 0)
  </code></pre>
  
  <p>I want to get the <code>timeId</code> from the table <code>table_roaster_time_table</code> where <code>userid</code> will be provided and the date is today.</p>
  
  <p>How do I do this?</p>