title: How to retrieve records for last 30 minutes in MS SQL?
body: <p>I want to retrieve records for last 30 minutes in a table. How to do that? Below is my query..</p>
  
  <pre><code>select * from
  [Janus999DB].[dbo].[tblCustomerPlay]
  where DatePlayed &lt; CURRENT_TIMESTAMP
  and DatePlayed &gt;
  (CURRENT_TIMESTAMP-30)
  </code></pre>