title: how to get records of previous day using tsql?
body: <p>I need all the records from last day?</p>
  
  <p>Hi </p>
  
  <pre><code>Select * from table1 where tabledate &gt; getdate() -1 
  </code></pre>
  
  <p>with this query, i need to run is exactly after midnight to get exact result. I need to run it  in day time and get all the previous day's records.</p>