computing elapsed time in minutes

[patnim17]

hi,
I need to compute the elapsed time in minutes, since an update occured in the table..and I am using this quesry to find thsi out..Just wnated to know if there would be a problem in using this:

select * from TABLE1 where date_last_modified < SYSDATE - (60/1440);

so in this case I wanted to know if any records are modified in the TABLE1 from the past 1 hour.??

Pat

 

[SkipVought]

Hi,

Everything WITHIN the last hour...

select * 
from TABLE1 
where  date_last_modified >= SYSDATE - (1/24);

Skip,

_[red][/red]