How to get last 5 minutes of data with datetime data type in SQL Server

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 4/15/2015 4:21:45 PM when I use

SELECT *
FROM ServiceRequest.DBO.History_Table
WHERE: Time = CONVERT(DATE, GETDATE())

I return all records with today's date, but how would I extend this so that I retrieve the last 5 minutes? My History_Table column is a date data type.

1 Answer

You should query from the parameter less five minutes using the DATEADD function

Then use the minutes parameter

WHERE [dateColumn] > DATEADD(minute, -5, GETUTCDATE())