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...
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())
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
