title: How to get last 5 minutes of data with datetime data type in SQL Server
body: <p>I would like to run a query against data that is being consumed by an Esri ArcGIS Server SQL Server database, the data reads as <code>4/15/2015 4:21:45 PM</code>  when I use </p>
  
  <pre><code>SELECT * 
  FROM ServiceRequest.DBO.History_Table 
  WHERE: Time = CONVERT(DATE, GETDATE())
  </code></pre>
  
  <p>I return all records with today's date, but how would I extend this so that I retrieve the last 5 minutes? My <code>History_Table</code> column is a <code>date</code> data type.</p>