date manipultation issue reg

[laxman]

Dear all,
i have one table

sql>desc request
Name                       NULL?             Type
 ---------------------- ---------       -----------------
reqid                      NOT NULL   NUMBER(10)
requestname                            Varchar2(20)
 STATUS                                       varchar2(10)
lastmoddate                            date

i need to retreive lastmoddate record based on some condition given below,also i have written query for each requirement,but date manipulation logic is correct or not i am not sure,kindly help me out to modify the logic if it is not correct.

Requirement one: search requests that have been assigned but in pending state for more than 24hrs

sql> SELECT reqid,requestname FROM request WHERE lastmoddate<sysdate - 1 AND STATUS='pending';

Requirement two: search requests that have been assigned but in escalated state for past 8 hrs

sql> SELECT reqid,requestname FROM request WHERE lastmoddate<sysdate - 8/24 AND STATUS='escalated';

Requirement two: search requests that have been assigned but in closed state for two weeks

sql> SELECT reqid,requestname FROM request WHERE lastmoddate>sysdate - 14 AND STATUS='closed';

Thanks n regards
Laxman

[rajavu]

All Fine Except last one. For the last one it should be < sign.

SELECT reqid,requestname FROM request WHERE lastmoddate<sysdate - 14 AND STATUS='closed';

Or you can use <= bases on your requirement.

[laxman]

thanks a lot sir.


Regards
Laxman