SQL Server Delete all rows more than 10 minutes old

Question

How can I delete All rows in SQL Server that were created later than 10 minutes. Thanks.

Answer 1

Assuming that you have a column name Date_column which is storing the timestamp. You may try like this, where mi is the abbreviation for minute:

DELETE FROM Table_name
WHERE Date_column < DATEADD(mi,-10,GETDATE())

Answer 2

SQL Server has no way to tell at what time the row was created. You will need to have an extra column in your table to log the time. If you do that, your delete statement becomes fairly straight forward.