date 3 month

[oracle_corrgi]

hi
i am getting output correctly with this query
select * from test where test_DATE < SYSDATE + 90
i need to get the out put as above query using this 2 second query
select * from test where sysdate-test_DATE between 0 and 91
thanxs

[wel]

hi, try this

SELECT *
FROM test
WHERE (SYSDATE-test_date) BETWEEN 0 AND 91;

[debasisdas]

Thats so simple
I dont understand why u put that in the forum when u know the ans..