title: SQL QUERY ( SQL SERVER) Date & Time Difference
body: <p>I have a SQL SERVER Table which has only one  field "StartDate" the records are as follows</p>
  
  <p>**
  2011-07-28 19:30:00.000</p>
  
  <p>2011-07-29 21:50:00.000</p>
  
  <p>2011-07-25 09:20:00.000
  **</p>
  
  <p>What i want to do is :</p>
  
  <p>SHOW RECORDS if its CURRENT DATE ( todays date ) and the time difference between current time the StartDate is not less then 5 minutes, i have written the following code but it doesnt show me the time difference ?</p>
  
  <pre><code>SELECT * FROM table WHERE DATEDIFF(day, StartDate, GETDATE()) &lt;= 0
  </code></pre>