I am trying to set up a job in sql server that will run an asp file...the file connects to an oracle database and runs a query on all rows in a table with a date that falls between the current system date and the time the job was last run (2 hours)

what would the syntax be for "where row_date >= sysdate - 2hours"?

thanks

select * from table
where to_char(rowDATE, 'DD-MON-YY:HH24') >= SYSDATE||':'||(to_char(SYSDATE, 'HH24')-2);

where row_date >= sysdate - interval '2' hour

thanks guys...appreciate the help