Well, you would select from a table and use a
where clause. Here is a simple method in Oracle:
select t.* from t where abs(date_columna - date_columnb) > 2 / 24
If you know that one column comes earlier than the other, then:
select t.* from t where date_columna > date_columnb + interval '2 hour'
Gordon Linoff posted this
Have an answer?