How to Print last 10 minutes result.

Question

How to Print last 10 minutes result in ORACLE-SQL, What is the query for that?

Answer 1

Is there a field in the table of your database that shows the datetime of entry? If so, use something like this:

SELECT *
FROM YourTable

WHERE DATEDIFF(mi, YourTable.DateTimeFieldName, GETDDATE()) <= 10

Answer 2

save the time (e.g. unix encoded time) as a record with programming language and calc.