Extract results updated in last 2 hours

Question

I am trying to write a query to extract records updated in the last 2 hours in SQL Server 2008.

Could anyone help me write this?

http://stackoverflow.com/questions/1888544/how-to-select-records-from-last-24-hours-using-sql — Nagaraj S, Jan 17 '14 at 12:39

score 1 · Answer 1 · answered Jan 17 '14 at 12:43

1

select * from table where table.date1>=dateadd(hh,-2,getdate())

dateadd() function lets you subtract hours from getdate() letting you choose records updated past 2 hours

answered Jan 17 '14 at 12:43

vhadalgi

7,027
6
38
67

How can I do this in oracle? – Eda Dec 17 '20 at 08:48

score 1 · Answer 2 · answered Jan 17 '14 at 15:32

First, you have to design the table so you have a field where the time of the last change will be stored

Then, whenever you update a row, update the value in the 'last update' field. After that, you can use a script such as suggested by Vijaykumar

The downside of this method is that when a single record was changed more than once in the specified time period, you will be notified only about the time of the last update.

Another solution for tracking the updates is to read the database online transaction log file, but you'll need a third party tool for that

Extract results updated in last 2 hours

2 Answers2